PREVIEW / etf_30min / 2011-06-23

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-23.parquet
  size:    289 KB
  rows:    9,540

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-06-23 04:00:00	SPY	ETF	128.0	128.17	128.0	128.14	2800.0
2011-06-23 04:30:00	SPY	ETF	128.0	128.06	128.0	128.06	2600.0
2011-06-23 05:00:00	SPY	ETF	128.0	128.02	127.81	127.81	1200.0
2011-06-23 05:30:00	SPY	ETF	127.81	127.93	127.8	127.82	11600.0
2011-06-23 06:00:00	SPY	ETF	127.84	128.05	127.84	127.91	1000.0
2011-06-23 06:30:00	SPY	ETF	127.85	127.85	127.7	127.7	50530.0
2011-06-23 07:00:00	SPY	ETF	127.75	127.89	127.6	127.64	326692.0
2011-06-23 07:30:00	SPY	ETF	127.67	127.79	127.6	127.63	199844.0
2011-06-23 08:00:00	SPY	ETF	127.65	127.67	127.37	127.45	2039371.0
2011-06-23 08:30:00	SPY	ETF	127.45	127.45	126.79	126.98	6150334.0
2011-06-23 09:00:00	SPY	ETF	126.98	127.31	126.87	127.17	3771944.0
2011-06-23 09:30:00	SPY	ETF	127.16	127.18	126.34	126.68	33813842.0
2011-06-23 10:00:00	SPY	ETF	126.69	127.03	126.37	126.695	28831881.0
2011-06-23 10:30:00	SPY	ETF	126.7	126.78	126.19	126.56	24304241.0
2011-06-23 11:00:00	SPY	ETF	126.57	126.74	126.39	126.7	15305487.0
2011-06-23 11:30:00	SPY	ETF	126.71	128.6361	126.65	126.87	19720915.0
2011-06-23 12:00:00	SPY	ETF	126.87	127.05	126.62	126.661	11489988.0
2011-06-23 12:30:00	SPY	ETF	126.67	127.13	126.63	127.1099	9412826.0
2011-06-23 13:00:00	SPY	ETF	127.11	127.39	127.06	127.28	13540327.0
2011-06-23 13:30:00	SPY	ETF	127.28	127.55	127.08	127.29	13835745.0
2011-06-23 14:00:00	SPY	ETF	127.29	127.3225	126.87	126.99	13696035.0
2011-06-23 14:30:00	SPY	ETF	126.99	127.83	126.63	127.82	22437550.0
2011-06-23 15:00:00	SPY	ETF	127.82	128.24	127.29	127.74	44421146.0
2011-06-23 15:30:00	SPY	ETF	127.74	128.37	127.35	128.31	37615457.0
2011-06-23 16:00:00	SPY	ETF	128.31	128.6361	126.5823	128.22	18833405.0
2011-06-23 16:30:00	SPY	ETF	128.21	128.6361	126.6009	128.6361	11043524.0
2011-06-23 17:00:00	SPY	ETF	128.38	128.46	128.29	128.38	201210.0
2011-06-23 17:30:00	SPY	ETF	128.34	128.43	128.31	128.4	77143.0
2011-06-23 18:00:00	SPY	ETF	128.38	128.84	128.27	128.64	514935.0
2011-06-23 18:30:00	SPY	ETF	128.62	128.65	128.58	128.6	55394.0
2011-06-23 19:00:00	SPY	ETF	128.6	128.65	128.58	128.6	39843.0
2011-06-23 19:30:00	SPY	ETF	128.55	128.59	128.51	128.59	26257.0
2011-06-23 05:30:00	QQQ	ETF	54.65	54.65	54.65	54.65	10000.0
2011-06-23 06:00:00	QQQ	ETF	54.6	54.6	54.6	54.6	500.0
2011-06-23 06:30:00	QQQ	ETF	54.54	54.56	54.51	54.56	8177.0
2011-06-23 07:00:00	QQQ	ETF	54.55	54.59	54.49	54.49	15000.0
2011-06-23 07:30:00	QQQ	ETF	54.49	54.54	54.47	54.47	80412.0
2011-06-23 08:00:00	QQQ	ETF	54.47	54.48	54.4	54.43	295304.0
2011-06-23 08:30:00	QQQ	ETF	54.43	54.43	54.2	54.26	925128.0
2011-06-23 09:00:00	QQQ	ETF	54.26	54.35	54.22	54.27	927642.0
2011-06-23 09:30:00	QQQ	ETF	54.27	54.33	54.06	54.18	7825926.0
2011-06-23 10:00:00	QQQ	ETF	54.18	54.43	54.115	54.32	7668542.0
2011-06-23 10:30:00	QQQ	ETF	54.32	54.36	54.065	54.22	4907520.0
2011-06-23 11:00:00	QQQ	ETF	54.22	54.4	54.15	54.39	2924894.0
2011-06-23 11:30:00	QQQ	ETF	54.39	54.52	54.36	54.5	2849496.0
2011-06-23 12:00:00	QQQ	ETF	54.5	54.65	54.47	54.49	4032095.0
2011-06-23 12:30:00	QQQ	ETF	54.49	54.72	54.49	54.72	3572984.0
2011-06-23 13:00:00	QQQ	ETF	54.72	54.88	54.7	54.82	5028868.0
2011-06-23 13:30:00	QQQ	ETF	54.82	54.955	54.7	54.78	4097345.0
2011-06-23 14:00:00	QQQ	ETF	54.79	54.8099	54.56	54.62	3865350.0

> showing 50 of 9,540 rows — these rows as CSV

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