PREVIEW / etf_30min / 2011-08-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-01.parquet
  size:    303 KB
  rows:    10,097

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
2011-08-01 04:00:00	SPY	ETF	130.5	130.86	130.5	130.55	4550.0
2011-08-01 04:30:00	SPY	ETF	130.55	130.65	130.47	130.65	1495.0
2011-08-01 05:00:00	SPY	ETF	130.75	130.79	130.68	130.79	23640.0
2011-08-01 05:30:00	SPY	ETF	130.86	130.89	130.77	130.85	17200.0
2011-08-01 06:00:00	SPY	ETF	130.93	131.05	130.88	131.0	36240.0
2011-08-01 06:30:00	SPY	ETF	131.0	131.3	130.95	131.23	110112.0
2011-08-01 07:00:00	SPY	ETF	131.25	131.35	130.89	131.07	509464.0
2011-08-01 07:30:00	SPY	ETF	131.07	131.07	130.82	130.88	494719.0
2011-08-01 08:00:00	SPY	ETF	130.92	131.4	129.33	130.93	3222476.0
2011-08-01 08:30:00	SPY	ETF	130.94	130.97	130.54	130.62	1859087.0
2011-08-01 09:00:00	SPY	ETF	130.62	130.86	129.05	130.84	2907608.0
2011-08-01 09:30:00	SPY	ETF	130.84	130.96	129.65	129.68	39049772.0
2011-08-01 10:00:00	SPY	ETF	129.65	129.679	128.07	128.61	52091459.0
2011-08-01 10:30:00	SPY	ETF	128.6	128.93	128.5	128.54	20612959.0
2011-08-01 11:00:00	SPY	ETF	128.55	128.59	128.08	128.49	22474744.0
2011-08-01 11:30:00	SPY	ETF	128.49	128.5185	127.61	127.69	24937442.0
2011-08-01 12:00:00	SPY	ETF	127.69	127.95	127.53	127.88	18894047.0
2011-08-01 12:30:00	SPY	ETF	127.88	128.11	127.76	128.0	10994032.0
2011-08-01 13:00:00	SPY	ETF	127.99	128.13	127.8	127.97	11498001.0
2011-08-01 13:30:00	SPY	ETF	127.96	128.19	127.95	128.185	7425727.0
2011-08-01 14:00:00	SPY	ETF	128.19	128.19	127.73	127.886	12335141.0
2011-08-01 14:30:00	SPY	ETF	127.88	128.51	127.81	128.45	11542792.0
2011-08-01 15:00:00	SPY	ETF	128.46	128.85	128.39	128.76	15183326.0
2011-08-01 15:30:00	SPY	ETF	128.77	129.0	128.39	128.79	40628707.0
2011-08-01 16:00:00	SPY	ETF	128.79	128.8	128.06	128.46	10172238.0
2011-08-01 16:30:00	SPY	ETF	128.44	130.97	128.31	128.43	10170030.0
2011-08-01 17:00:00	SPY	ETF	128.43	128.43	128.22	128.22	5324477.0
2011-08-01 17:30:00	SPY	ETF	128.3	128.33	128.2	128.28	203000.0
2011-08-01 18:00:00	SPY	ETF	128.29	128.71	128.29	128.56	422017.0
2011-08-01 18:30:00	SPY	ETF	128.56	128.76	128.49	128.73	195313.0
2011-08-01 19:00:00	SPY	ETF	128.72	128.98	128.51	128.65	339366.0
2011-08-01 19:30:00	SPY	ETF	128.63	128.69	128.51	128.69	157377.0
2011-08-01 04:00:00	QQQ	ETF	58.58	58.58	58.53	58.53	2947.0
2011-08-01 04:30:00	QQQ	ETF	58.55	58.58	58.5	58.58	12600.0
2011-08-01 05:00:00	QQQ	ETF	58.57	58.58	58.57	58.58	2000.0
2011-08-01 05:30:00	QQQ	ETF	58.58	58.62	58.53	58.62	5500.0
2011-08-01 06:00:00	QQQ	ETF	58.63	58.65	58.63	58.65	2000.0
2011-08-01 06:30:00	QQQ	ETF	58.6	58.8	58.6	58.8	3900.0
2011-08-01 07:00:00	QQQ	ETF	58.72	58.8	58.65	58.68	51998.0
2011-08-01 07:30:00	QQQ	ETF	58.68	58.68	58.59	58.61	62604.0
2011-08-01 08:00:00	QQQ	ETF	58.62	58.7	58.58	58.67	501145.0
2011-08-01 08:30:00	QQQ	ETF	58.67	58.69	58.5	58.53	585102.0
2011-08-01 09:00:00	QQQ	ETF	58.53	58.69	58.53	58.67	1162031.0
2011-08-01 09:30:00	QQQ	ETF	58.67	58.82	58.14	58.17	10811595.0
2011-08-01 10:00:00	QQQ	ETF	58.17	58.175	57.48	57.65	17719559.0
2011-08-01 10:30:00	QQQ	ETF	57.65	57.84	57.57	57.68	6175251.0
2011-08-01 11:00:00	QQQ	ETF	57.68	57.69	57.4	57.61	5606020.0
2011-08-01 11:30:00	QQQ	ETF	57.61	57.62	57.16	57.19	5560390.0
2011-08-01 12:00:00	QQQ	ETF	57.19	57.26	57.03	57.24	5507958.0
2011-08-01 12:30:00	QQQ	ETF	57.24	57.325	57.14	57.27	2598012.0

> showing 50 of 10,097 rows — these rows as CSV

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