PREVIEW / etf_30min / 2013-11-21

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-21.parquet
  size:    324 KB
  rows:    10,941

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
2013-11-21 04:00:00	SPY	ETF	178.47	178.6	178.34	178.57	122894.0
2013-11-21 04:30:00	SPY	ETF	178.6	178.8	178.6	178.71	30067.0
2013-11-21 05:00:00	SPY	ETF	178.69	178.84	178.66	178.84	24282.0
2013-11-21 05:30:00	SPY	ETF	178.84	178.89	178.81	178.89	7310.0
2013-11-21 06:00:00	SPY	ETF	178.84	178.89	178.81	178.86	19580.0
2013-11-21 06:30:00	SPY	ETF	178.84	178.84	178.68	178.75	9660.0
2013-11-21 07:00:00	SPY	ETF	178.76	178.77	178.7	178.7	27999.0
2013-11-21 07:30:00	SPY	ETF	178.74	178.96	178.72	178.88	85281.0
2013-11-21 08:00:00	SPY	ETF	178.88	179.11	178.82	178.95	367740.0
2013-11-21 08:30:00	SPY	ETF	178.98	179.07	178.81	178.82	469503.0
2013-11-21 09:00:00	SPY	ETF	178.82	179.03	178.81	178.98	440467.0
2013-11-21 09:30:00	SPY	ETF	178.97	179.36	178.86	179.27	9114041.0
2013-11-21 10:00:00	SPY	ETF	179.26	179.4	179.07	179.28	6507550.0
2013-11-21 10:30:00	SPY	ETF	179.27	179.68	179.27	179.57	6390227.0
2013-11-21 11:00:00	SPY	ETF	179.561	179.65	179.44	179.62	2843394.0
2013-11-21 11:30:00	SPY	ETF	179.62	179.71	179.43	179.62	4731045.0
2013-11-21 12:00:00	SPY	ETF	179.62	179.641	179.44	179.595	2870638.0
2013-11-21 12:30:00	SPY	ETF	179.61	179.62	179.36	179.38	3307151.0
2013-11-21 13:00:00	SPY	ETF	179.38	179.66	179.38	179.595	3310300.0
2013-11-21 13:30:00	SPY	ETF	179.59	179.89	179.59	179.84	5077898.0
2013-11-21 14:00:00	SPY	ETF	179.845	179.9	179.73	179.79	3546760.0
2013-11-21 14:30:00	SPY	ETF	179.79	179.965	179.71	179.87	3538301.0
2013-11-21 15:00:00	SPY	ETF	179.87	180.05	179.86	179.97	5804038.0
2013-11-21 15:30:00	SPY	ETF	179.97	180.0	179.76	179.88	14344645.0
2013-11-21 16:00:00	SPY	ETF	179.93	179.97	178.4463	179.89	7296373.0
2013-11-21 16:30:00	SPY	ETF	179.89	179.94	179.86	179.91	2792060.0
2013-11-21 17:00:00	SPY	ETF	179.91	179.94	178.4463	179.88	638646.0
2013-11-21 17:30:00	SPY	ETF	179.88	179.88	179.86	179.87	14410.0
2013-11-21 18:00:00	SPY	ETF	179.86	179.98	179.83	179.97	380142.0
2013-11-21 18:30:00	SPY	ETF	179.97	180.02	179.95	179.98	635096.0
2013-11-21 19:00:00	SPY	ETF	179.97	180.0	179.94	180.0	5852.0
2013-11-21 19:30:00	SPY	ETF	179.98	180.01	179.93	180.0	28267.0
2013-11-21 04:00:00	QQQ	ETF	82.61	82.61	82.58	82.58	400.0
2013-11-21 04:30:00	QQQ	ETF	82.75	82.81	82.75	82.81	6700.0
2013-11-21 05:00:00	QQQ	ETF	82.82	82.91	82.79	82.91	12100.0
2013-11-21 06:00:00	QQQ	ETF	82.92	82.92	82.92	82.92	3000.0
2013-11-21 06:30:00	QQQ	ETF	82.88	82.89	82.82	82.86	19767.0
2013-11-21 07:00:00	QQQ	ETF	82.84	82.85	82.83	82.83	27500.0
2013-11-21 07:30:00	QQQ	ETF	82.84	82.94	82.84	82.94	10311.0
2013-11-21 08:00:00	QQQ	ETF	82.9	83.01	82.9	82.98	114988.0
2013-11-21 08:30:00	QQQ	ETF	82.97	82.97	82.9	82.93	49960.0
2013-11-21 09:00:00	QQQ	ETF	82.92	83.06	82.92	83.02	28614.0
2013-11-21 09:30:00	QQQ	ETF	83.02	83.34	82.98	83.28	4601965.0
2013-11-21 10:00:00	QQQ	ETF	83.28	83.33	83.2	83.22	2266947.0
2013-11-21 10:30:00	QQQ	ETF	83.23	83.37	83.23	83.29	1991984.0
2013-11-21 11:00:00	QQQ	ETF	83.29	83.34	83.18	83.27	1055376.0
2013-11-21 11:30:00	QQQ	ETF	83.28	83.32	83.19	83.26	910557.0
2013-11-21 12:00:00	QQQ	ETF	83.26	83.29	83.16	83.289	553247.0
2013-11-21 12:30:00	QQQ	ETF	83.285	83.29	83.1	83.119	609385.0
2013-11-21 13:00:00	QQQ	ETF	83.115	83.3	83.11	83.28	848444.0

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

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