PREVIEW / etf_30min / 2009-07-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-07-30.parquet
  size:    232 KB
  rows:    7,634

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2009-07-30 04:00:00	SPY	ETF	98.1	98.23	98.1	98.23	3668.0
2009-07-30 04:30:00	SPY	ETF	98.33	98.53	98.33	98.53	11750.0
2009-07-30 05:00:00	SPY	ETF	98.53	98.67	98.53	98.67	11811.0
2009-07-30 05:30:00	SPY	ETF	98.7	98.7	98.65	98.66	5300.0
2009-07-30 06:00:00	SPY	ETF	98.65	98.85	98.65	98.82	16800.0
2009-07-30 06:30:00	SPY	ETF	98.8	98.8	98.67	98.67	42624.0
2009-07-30 07:00:00	SPY	ETF	98.68	98.74	98.6	98.61	188099.0
2009-07-30 07:30:00	SPY	ETF	98.6	98.66	98.55	98.65	641995.0
2009-07-30 08:00:00	SPY	ETF	98.65	98.81	98.49	98.61	2500805.0
2009-07-30 08:30:00	SPY	ETF	98.6	99.1	98.19	98.96	5362002.0
2009-07-30 09:00:00	SPY	ETF	98.98	99.05	98.81	98.83	1592198.0
2009-07-30 09:30:00	SPY	ETF	98.83	99.47	98.6	99.41	28070710.0
2009-07-30 10:00:00	SPY	ETF	99.4	99.72	99.32	99.55	22146154.0
2009-07-30 10:30:00	SPY	ETF	99.55	99.83	99.48	99.74	13001860.0
2009-07-30 11:00:00	SPY	ETF	99.74	99.8	99.28	99.48	11920445.0
2009-07-30 11:30:00	SPY	ETF	99.48	99.56	99.15	99.21	12780324.0
2009-07-30 12:00:00	SPY	ETF	99.21	99.38	99.15	99.19	9331484.0
2009-07-30 12:30:00	SPY	ETF	99.19	99.41	99.1803	99.28	6088193.0
2009-07-30 13:00:00	SPY	ETF	99.275	99.58	99.25	99.45	12297215.0
2009-07-30 13:30:00	SPY	ETF	99.46	99.64	99.35	99.365	7826792.0
2009-07-30 14:00:00	SPY	ETF	99.39	99.46	99.2	99.3717	9284047.0
2009-07-30 14:30:00	SPY	ETF	99.37	99.51	99.3	99.39	7710152.0
2009-07-30 15:00:00	SPY	ETF	99.39	99.63	99.381	99.51	10573428.0
2009-07-30 15:30:00	SPY	ETF	99.51	99.52	98.655	98.71	39030526.0
2009-07-30 16:00:00	SPY	ETF	98.7	99.7	98.56	98.66	13269757.0
2009-07-30 16:30:00	SPY	ETF	98.65	98.7	98.55	98.61	457715.0
2009-07-30 17:00:00	SPY	ETF	98.61	98.62	98.55	98.59	190297.0
2009-07-30 17:30:00	SPY	ETF	98.57	99.025	98.55	98.6	44990.0
2009-07-30 18:00:00	SPY	ETF	98.58	98.74	98.57	98.58	36099.0
2009-07-30 18:30:00	SPY	ETF	98.64	98.71	98.64	98.68	65757.0
2009-07-30 19:00:00	SPY	ETF	98.7	98.76	98.68	98.74	30716.0
2009-07-30 19:30:00	SPY	ETF	98.75	99.01	98.68	98.7	59784.0
2009-07-30 04:00:00	QQQ	ETF	39.6	39.6	39.6	39.6	539.0
2009-07-30 04:30:00	QQQ	ETF	39.63	39.65	39.63	39.65	200.0
2009-07-30 05:00:00	QQQ	ETF	39.65	39.69	39.65	39.69	5400.0
2009-07-30 05:30:00	QQQ	ETF	39.7	39.71	39.66	39.66	10370.0
2009-07-30 06:00:00	QQQ	ETF	39.75	39.75	39.75	39.75	1210.0
2009-07-30 06:30:00	QQQ	ETF	39.66	39.7	39.66	39.7	1600.0
2009-07-30 07:00:00	QQQ	ETF	39.66	39.67	39.61	39.61	63600.0
2009-07-30 07:30:00	QQQ	ETF	39.62	39.68	39.62	39.67	109081.0
2009-07-30 08:00:00	QQQ	ETF	39.67	39.77	39.61	39.75	763888.0
2009-07-30 08:30:00	QQQ	ETF	39.68	39.82	39.66	39.79	734506.0
2009-07-30 09:00:00	QQQ	ETF	39.79	39.81	39.72	39.73	321323.0
2009-07-30 09:30:00	QQQ	ETF	39.74	40.05	39.65	40.03	16838972.0
2009-07-30 10:00:00	QQQ	ETF	40.0399	40.11	39.96	40.04	9359342.0
2009-07-30 10:30:00	QQQ	ETF	40.05	40.18	40.01	40.08	6739903.0
2009-07-30 11:00:00	QQQ	ETF	40.09	40.11	39.94	39.94	4970023.0
2009-07-30 11:30:00	QQQ	ETF	39.9401	40.0769	39.82	39.83	6203282.0
2009-07-30 12:00:00	QQQ	ETF	39.8299	39.86	39.77	39.79	3938249.0
2009-07-30 12:30:00	QQQ	ETF	39.79	39.88	39.79	39.8	3903275.0

> showing 50 of 7,634 rows — these rows as CSV

> unlock the full archive -- $79 one-time