PREVIEW / etf_30min / 2015-06-22

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-22.parquet
  size:    379 KB
  rows:    12,927

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
2015-06-22 04:00:00	SPY	ETF	211.65	212.19	211.65	212.19	27801.0
2015-06-22 04:30:00	SPY	ETF	212.21	212.21	212.08	212.17	10601.0
2015-06-22 05:00:00	SPY	ETF	212.1	212.17	212.0	212.05	13376.0
2015-06-22 05:30:00	SPY	ETF	212.07	212.12	211.94	211.94	9970.0
2015-06-22 06:00:00	SPY	ETF	211.93	212.09	211.93	211.94	25036.0
2015-06-22 06:30:00	SPY	ETF	211.94	211.98	210.6	211.57	138330.0
2015-06-22 07:00:00	SPY	ETF	211.57	211.89	211.56	211.73	245136.0
2015-06-22 07:30:00	SPY	ETF	211.69	211.93	211.66	211.83	258892.0
2015-06-22 08:00:00	SPY	ETF	211.83	211.89	211.52	211.68	405542.0
2015-06-22 08:30:00	SPY	ETF	211.68	211.76	211.47	211.57	609759.0
2015-06-22 09:00:00	SPY	ETF	211.57	212.14	211.54	211.9	1269125.0
2015-06-22 09:30:00	SPY	ETF	211.905	212.18	211.69	212.09	9721522.0
2015-06-22 10:00:00	SPY	ETF	212.08	212.31	211.97	212.14	5973516.0
2015-06-22 10:30:00	SPY	ETF	212.15	212.46	212.1	212.3445	6048347.0
2015-06-22 11:00:00	SPY	ETF	212.35	212.59	212.19	212.51	4351586.0
2015-06-22 11:30:00	SPY	ETF	212.51	212.56	212.14	212.18	3884907.0
2015-06-22 12:00:00	SPY	ETF	212.17	212.21	211.64	211.77	4828325.0
2015-06-22 12:30:00	SPY	ETF	211.769	212.02	211.74	211.9862	2324020.0
2015-06-22 13:00:00	SPY	ETF	211.98	212.5	211.71	211.71	2097269.0
2015-06-22 13:30:00	SPY	ETF	211.72	211.95	211.68	211.95	2891749.0
2015-06-22 14:00:00	SPY	ETF	211.955	212.0	211.86	211.88	2730788.0
2015-06-22 14:30:00	SPY	ETF	211.87	212.15	211.81	212.07	3133148.0
2015-06-22 15:00:00	SPY	ETF	212.06	212.09	211.925	211.971	2963456.0
2015-06-22 15:30:00	SPY	ETF	211.98	212.03	211.74	211.9	10377312.0
2015-06-22 16:00:00	SPY	ETF	211.92	211.92	211.55	211.75	4541972.0
2015-06-22 16:30:00	SPY	ETF	211.76	211.94	211.74	211.88	875880.0
2015-06-22 17:00:00	SPY	ETF	211.9	211.98	211.86	211.97	102977.0
2015-06-22 17:30:00	SPY	ETF	211.97	211.97	211.89	211.9	81462.0
2015-06-22 18:00:00	SPY	ETF	211.9	211.98	211.86	211.98	73947.0
2015-06-22 18:30:00	SPY	ETF	211.98	212.0	211.98	212.0	15930.0
2015-06-22 19:00:00	SPY	ETF	212.0	212.13	212.0	212.1	26396.0
2015-06-22 19:30:00	SPY	ETF	212.12	212.12	212.04	212.05	20520.0
2015-06-22 04:00:00	QQQ	ETF	110.62	110.9	110.62	110.8	18419.0
2015-06-22 04:30:00	QQQ	ETF	110.91	110.91	110.76	110.76	1300.0
2015-06-22 05:30:00	QQQ	ETF	110.89	110.89	110.89	110.89	1800.0
2015-06-22 06:00:00	QQQ	ETF	110.9	110.9	110.75	110.88	11700.0
2015-06-22 06:30:00	QQQ	ETF	110.88	110.88	110.62	110.62	4400.0
2015-06-22 07:00:00	QQQ	ETF	110.65	110.8	110.65	110.67	28499.0
2015-06-22 07:30:00	QQQ	ETF	110.7	110.76	110.68	110.73	22491.0
2015-06-22 08:00:00	QQQ	ETF	110.68	110.76	110.36	110.6	43707.0
2015-06-22 08:30:00	QQQ	ETF	110.6	110.63	110.53	110.57	166529.0
2015-06-22 09:00:00	QQQ	ETF	110.58	110.82	110.58	110.69	393034.0
2015-06-22 09:30:00	QQQ	ETF	110.7	110.89	110.541	110.75	2965319.0
2015-06-22 10:00:00	QQQ	ETF	110.76	110.9	110.68	110.74	1691343.0
2015-06-22 10:30:00	QQQ	ETF	110.74	110.85	110.6601	110.78	952613.0
2015-06-22 11:00:00	QQQ	ETF	110.78	111.03	110.7	111.01	1506532.0
2015-06-22 11:30:00	QQQ	ETF	111.0	111.03	110.84	110.8599	1004519.0
2015-06-22 12:00:00	QQQ	ETF	110.86	110.875	110.5	110.56	1252396.0
2015-06-22 12:30:00	QQQ	ETF	110.56	110.71	110.54	110.699	1032823.0
2015-06-22 13:00:00	QQQ	ETF	110.6935	110.7	110.51	110.51	478224.0

> showing 50 of 12,927 rows — these rows as CSV

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