PREVIEW / etf_30min / 2012-11-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-06.parquet
  size:    286 KB
  rows:    9,512

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
2012-11-06 04:00:00	SPY	ETF	142.04	142.11	142.04	142.08	21400.0
2012-11-06 04:30:00	SPY	ETF	142.15	142.22	142.15	142.22	11001.0
2012-11-06 05:00:00	SPY	ETF	142.17	142.39	142.17	142.36	11800.0
2012-11-06 05:30:00	SPY	ETF	142.35	142.35	142.2	142.28	22049.0
2012-11-06 06:30:00	SPY	ETF	142.27	142.38	142.27	142.32	32848.0
2012-11-06 07:00:00	SPY	ETF	142.35	142.41	142.22	142.23	71198.0
2012-11-06 07:30:00	SPY	ETF	142.25	142.25	142.09	142.14	16478.0
2012-11-06 08:00:00	SPY	ETF	142.1	142.27	141.99	142.25	384293.0
2012-11-06 08:30:00	SPY	ETF	142.26	142.35	142.24	142.28	187220.0
2012-11-06 09:00:00	SPY	ETF	142.29	142.34	142.19	142.28	254739.0
2012-11-06 09:30:00	SPY	ETF	142.28	142.58	142.13	142.56	11349180.0
2012-11-06 10:00:00	SPY	ETF	142.56	142.57	142.26	142.338	6203334.0
2012-11-06 10:30:00	SPY	ETF	142.33	142.62	142.16	142.42	5007510.0
2012-11-06 11:00:00	SPY	ETF	142.43	142.59	142.37	142.5	3976466.0
2012-11-06 11:30:00	SPY	ETF	142.5	143.265	142.49	143.2	12256390.0
2012-11-06 12:00:00	SPY	ETF	143.2	143.52	143.17	143.345	7555640.0
2012-11-06 12:30:00	SPY	ETF	143.35	143.38	143.06	143.18	4749236.0
2012-11-06 13:00:00	SPY	ETF	143.18	143.34	143.08	143.27	4038156.0
2012-11-06 13:30:00	SPY	ETF	143.28	143.39	143.18	143.22	3230284.0
2012-11-06 14:00:00	SPY	ETF	143.21	143.28	143.12	143.25	3176143.0
2012-11-06 14:30:00	SPY	ETF	143.26	143.35	142.98	143.08	4335774.0
2012-11-06 15:00:00	SPY	ETF	143.08	143.11	142.88	142.955	5734143.0
2012-11-06 15:30:00	SPY	ETF	142.95	143.08	142.79	142.92	22233743.0
2012-11-06 16:00:00	SPY	ETF	142.92	143.3409	142.23	143.1	4872794.0
2012-11-06 16:30:00	SPY	ETF	143.1	143.26	143.016	143.24	4527727.0
2012-11-06 17:00:00	SPY	ETF	143.2	143.23	143.1	143.1	58236.0
2012-11-06 17:30:00	SPY	ETF	143.1	143.15	143.07	143.11	14799.0
2012-11-06 18:00:00	SPY	ETF	143.11	143.18	143.04	143.04	82149.0
2012-11-06 18:30:00	SPY	ETF	143.06	143.06	142.89	142.98	42705.0
2012-11-06 19:00:00	SPY	ETF	142.97	142.97	142.75	142.76	143579.0
2012-11-06 19:30:00	SPY	ETF	142.76	142.78	142.57	142.67	236649.0
2012-11-06 04:30:00	QQQ	ETF	65.76	65.76	65.76	65.76	3918.0
2012-11-06 05:00:00	QQQ	ETF	65.77	65.77	65.76	65.77	1100.0
2012-11-06 06:00:00	QQQ	ETF	65.72	65.72	65.72	65.72	500.0
2012-11-06 06:30:00	QQQ	ETF	65.79	65.79	65.79	65.79	6300.0
2012-11-06 07:00:00	QQQ	ETF	65.79	65.79	65.73	65.73	7029.0
2012-11-06 07:30:00	QQQ	ETF	65.73	65.74	65.67	65.69	11614.0
2012-11-06 08:00:00	QQQ	ETF	65.7	65.75	65.63	65.73	35810.0
2012-11-06 08:30:00	QQQ	ETF	65.75	65.78	65.73	65.76	41299.0
2012-11-06 09:00:00	QQQ	ETF	65.75	65.75	65.68	65.72	37468.0
2012-11-06 09:30:00	QQQ	ETF	65.71	65.72	65.51	65.65	3189480.0
2012-11-06 10:00:00	QQQ	ETF	65.65	65.66	65.46	65.5699	1897175.0
2012-11-06 10:30:00	QQQ	ETF	65.56	65.7	65.47	65.63	2225098.0
2012-11-06 11:00:00	QQQ	ETF	65.63	65.68	65.59	65.62	1235170.0
2012-11-06 11:30:00	QQQ	ETF	65.61	66.0	65.59	65.98	3955525.0
2012-11-06 12:00:00	QQQ	ETF	65.97	66.17	65.97	66.02	3893355.0
2012-11-06 12:30:00	QQQ	ETF	66.02	66.07	65.89	65.96	1918789.0
2012-11-06 13:00:00	QQQ	ETF	65.96	65.98	65.87	65.9401	1135847.0
2012-11-06 13:30:00	QQQ	ETF	65.95	66.02	65.881	65.9	990872.0
2012-11-06 14:00:00	QQQ	ETF	65.89	65.94	65.83	65.91	792986.0

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

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