PREVIEW / etf_30min / 2011-11-16

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-16.parquet
  size:    288 KB
  rows:    9,596

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-11-16 04:00:00	SPY	ETF	125.76	125.9	125.62	125.72	9050.0
2011-11-16 04:30:00	SPY	ETF	125.75	126.22	125.75	126.19	45990.0
2011-11-16 05:00:00	SPY	ETF	126.27	126.34	126.2	126.2	112125.0
2011-11-16 05:30:00	SPY	ETF	126.13	126.13	124.93	124.99	129520.0
2011-11-16 06:00:00	SPY	ETF	125.12	125.12	124.49	124.93	107302.0
2011-11-16 06:30:00	SPY	ETF	124.93	125.07	124.55	124.84	207864.0
2011-11-16 07:00:00	SPY	ETF	124.87	125.48	124.65	125.28	775229.0
2011-11-16 07:30:00	SPY	ETF	125.25	125.38	124.95	125.09	695920.0
2011-11-16 08:00:00	SPY	ETF	125.09	125.83	124.52	125.08	2511889.0
2011-11-16 08:30:00	SPY	ETF	125.05	125.11	124.61	124.7	2555214.0
2011-11-16 09:00:00	SPY	ETF	124.7	124.94	124.46	124.83	2047970.0
2011-11-16 09:30:00	SPY	ETF	124.81	125.39	124.65	125.21	23402232.0
2011-11-16 10:00:00	SPY	ETF	125.22	125.38	124.86	124.975	14317935.0
2011-11-16 10:30:00	SPY	ETF	124.97	125.67	124.83	125.5989	15192938.0
2011-11-16 11:00:00	SPY	ETF	125.585	126.0	125.58	125.77	10971593.0
2011-11-16 11:30:00	SPY	ETF	125.77	125.87	125.36	125.4	14003167.0
2011-11-16 12:00:00	SPY	ETF	125.41	126.1277	125.3	125.375	8446831.0
2011-11-16 12:30:00	SPY	ETF	125.38	125.74	125.36	125.53	6792449.0
2011-11-16 13:00:00	SPY	ETF	125.53	126.03	125.51	126.0199	6586108.0
2011-11-16 13:30:00	SPY	ETF	126.01	126.34	125.91	126.04	12654422.0
2011-11-16 14:00:00	SPY	ETF	126.04	126.15	125.83	126.005	8274608.0
2011-11-16 14:30:00	SPY	ETF	126.01	126.11	125.57	125.71	10693796.0
2011-11-16 15:00:00	SPY	ETF	125.72	125.78	124.78	124.8095	22276216.0
2011-11-16 15:30:00	SPY	ETF	124.805	124.81	123.9	124.09	51361002.0
2011-11-16 16:00:00	SPY	ETF	124.09	126.1277	123.63	123.74	11146542.0
2011-11-16 16:30:00	SPY	ETF	123.74	125.2408	123.42	123.62	4766082.0
2011-11-16 17:00:00	SPY	ETF	123.62	124.05	123.41	123.52	1413066.0
2011-11-16 17:30:00	SPY	ETF	123.56	123.6	123.5	123.52	2107584.0
2011-11-16 18:00:00	SPY	ETF	123.54	124.05	123.34	123.44	355570.0
2011-11-16 18:30:00	SPY	ETF	123.43	123.62	123.35	123.55	200952.0
2011-11-16 19:00:00	SPY	ETF	123.53	123.73	123.52	123.6	173175.0
2011-11-16 19:30:00	SPY	ETF	123.61	123.66	123.3	123.41	279580.0
2011-11-16 04:00:00	QQQ	ETF	58.0	58.02	57.96	57.96	600.0
2011-11-16 04:30:00	QQQ	ETF	58.03	58.09	58.02	58.02	800.0
2011-11-16 05:00:00	QQQ	ETF	58.22	58.22	58.21	58.21	400.0
2011-11-16 05:30:00	QQQ	ETF	58.04	58.04	57.82	57.82	600.0
2011-11-16 06:00:00	QQQ	ETF	57.79	57.81	57.54	57.61	15900.0
2011-11-16 06:30:00	QQQ	ETF	57.6	57.7	57.54	57.7	3200.0
2011-11-16 07:00:00	QQQ	ETF	57.67	57.97	57.59	57.88	105700.0
2011-11-16 07:30:00	QQQ	ETF	57.87	57.92	57.78	57.79	12840.0
2011-11-16 08:00:00	QQQ	ETF	57.83	57.89	57.63	57.83	142849.0
2011-11-16 08:30:00	QQQ	ETF	57.81	57.85	57.65	57.68	276829.0
2011-11-16 09:00:00	QQQ	ETF	57.67	57.79	57.67	57.72	212235.0
2011-11-16 09:30:00	QQQ	ETF	57.73	57.94	57.55	57.84	8907000.0
2011-11-16 10:00:00	QQQ	ETF	57.84	57.92	57.6	57.6421	4357186.0
2011-11-16 10:30:00	QQQ	ETF	57.64	58.0	57.59	57.95	3814071.0
2011-11-16 11:00:00	QQQ	ETF	57.95	58.07	57.93	57.95	2767364.0
2011-11-16 11:30:00	QQQ	ETF	57.95	58.01	57.73	57.75	3103054.0
2011-11-16 12:00:00	QQQ	ETF	57.75	57.82	57.7	57.7593	1780649.0
2011-11-16 12:30:00	QQQ	ETF	57.755	57.92	57.74	57.8193	2262128.0

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

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