PREVIEW / etf_30min / 2011-03-18

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-18.parquet
  size:    280 KB
  rows:    9,382

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-03-18 04:00:00	SPY	ETF	128.35	128.35	128.1	128.16	10200.0
2011-03-18 04:30:00	SPY	ETF	128.23	128.26	128.2	128.21	600.0
2011-03-18 05:00:00	SPY	ETF	128.06	128.12	127.88	128.05	19000.0
2011-03-18 05:30:00	SPY	ETF	128.01	128.04	127.99	127.99	2326.0
2011-03-18 06:00:00	SPY	ETF	128.2	128.2	127.79	127.9	16800.0
2011-03-18 06:30:00	SPY	ETF	127.95	128.19	127.95	128.15	130550.0
2011-03-18 07:00:00	SPY	ETF	128.15	128.3	128.05	128.24	176320.0
2011-03-18 07:30:00	SPY	ETF	128.24	128.44	128.22	128.22	350017.0
2011-03-18 08:00:00	SPY	ETF	128.22	128.32	127.88	128.23	2609315.0
2011-03-18 08:30:00	SPY	ETF	128.24	129.13	128.23	128.8	9660603.0
2011-03-18 09:00:00	SPY	ETF	128.8	129.11	127.85	128.84	4754136.0
2011-03-18 09:30:00	SPY	ETF	128.84	128.88	128.46	128.62	29007320.0
2011-03-18 10:00:00	SPY	ETF	128.625	128.68	128.15	128.19	18155408.0
2011-03-18 10:30:00	SPY	ETF	128.19	128.55	128.08	128.47	11459220.0
2011-03-18 11:00:00	SPY	ETF	128.47	128.72	128.03	128.04	16309140.0
2011-03-18 11:30:00	SPY	ETF	128.05	128.469	127.91	128.17	17709702.0
2011-03-18 12:00:00	SPY	ETF	128.17	128.42	128.09	128.34	7296793.0
2011-03-18 12:30:00	SPY	ETF	128.35	128.37	128.08	128.09	4902404.0
2011-03-18 13:00:00	SPY	ETF	128.09	128.37	128.09	128.27	3816440.0
2011-03-18 13:30:00	SPY	ETF	128.27	128.35	128.14	128.17	5841877.0
2011-03-18 14:00:00	SPY	ETF	128.1681	128.25	127.7	127.911	11325344.0
2011-03-18 14:30:00	SPY	ETF	127.9005	128.08	127.56	127.65	13372860.0
2011-03-18 15:00:00	SPY	ETF	127.65	127.745	127.51	127.59	12742584.0
2011-03-18 15:30:00	SPY	ETF	127.6	127.86	127.59	127.79	28321148.0
2011-03-18 16:00:00	SPY	ETF	127.8	128.64	127.2849	127.72	19987440.0
2011-03-18 16:30:00	SPY	ETF	127.72	128.0167	127.57	127.65	3461060.0
2011-03-18 17:00:00	SPY	ETF	127.66	127.89	127.6	127.86	2946974.0
2011-03-18 17:30:00	SPY	ETF	127.88	127.98	127.63	127.67	315908.0
2011-03-18 18:00:00	SPY	ETF	127.73	127.79	127.58	127.6	120612.0
2011-03-18 18:30:00	SPY	ETF	127.59	127.69	127.58	127.63	36209.0
2011-03-18 19:00:00	SPY	ETF	127.64	127.73	127.57	127.57	48538.0
2011-03-18 19:30:00	SPY	ETF	127.58	127.76	127.58	127.63	774190.0
2011-03-18 04:00:00	QQQ	ETF	54.93	55.06	54.93	54.97	4565.0
2011-03-18 05:00:00	QQQ	ETF	55.0	55.05	54.96	55.02	23604.0
2011-03-18 05:30:00	QQQ	ETF	54.96	54.96	54.95	54.95	15000.0
2011-03-18 06:30:00	QQQ	ETF	54.97	55.0	54.97	55.0	20106.0
2011-03-18 07:00:00	QQQ	ETF	55.0	55.09	55.0	55.04	61227.0
2011-03-18 07:30:00	QQQ	ETF	55.05	55.12	55.05	55.05	30872.0
2011-03-18 08:00:00	QQQ	ETF	55.04	55.11	54.99	55.01	542920.0
2011-03-18 08:30:00	QQQ	ETF	55.02	55.26	55.01	55.13	1721453.0
2011-03-18 09:00:00	QQQ	ETF	55.13	55.35	54.66	55.2	1418953.0
2011-03-18 09:30:00	QQQ	ETF	55.2	55.22	54.92	54.95	9458549.0
2011-03-18 10:00:00	QQQ	ETF	54.95	54.97	54.6	54.63	16339262.0
2011-03-18 10:30:00	QQQ	ETF	54.63	54.83	54.57	54.77	5383410.0
2011-03-18 11:00:00	QQQ	ETF	54.7784	54.85	54.55	54.56	4209705.0
2011-03-18 11:30:00	QQQ	ETF	54.555	54.681	54.43	54.4925	6903181.0
2011-03-18 12:00:00	QQQ	ETF	54.49	54.725	54.49	54.68	6799161.0
2011-03-18 12:30:00	QQQ	ETF	54.69	54.715	54.6	54.63	2902272.0
2011-03-18 13:00:00	QQQ	ETF	54.64	54.8	54.63	54.76	2927813.0
2011-03-18 13:30:00	QQQ	ETF	54.76	54.87	54.725	54.79	2404831.0

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

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