PREVIEW / etf_30min / 2015-04-27

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-04-27.parquet
  size:    390 KB
  rows:    13,137

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-04-27 04:00:00	SPY	ETF	211.73	211.88	211.73	211.82	2515.0
2015-04-27 04:30:00	SPY	ETF	211.78	211.78	211.74	211.74	400.0
2015-04-27 05:00:00	SPY	ETF	211.65	211.65	211.65	211.65	100.0
2015-04-27 05:30:00	SPY	ETF	211.85	211.87	211.85	211.87	2905.0
2015-04-27 06:00:00	SPY	ETF	211.96	212.05	211.94	212.05	16428.0
2015-04-27 06:30:00	SPY	ETF	212.1	212.21	212.07	212.14	34070.0
2015-04-27 07:00:00	SPY	ETF	212.21	212.3	212.07	212.08	66093.0
2015-04-27 07:30:00	SPY	ETF	212.1	212.16	212.06	212.15	35502.0
2015-04-27 08:00:00	SPY	ETF	212.14	212.16	212.08	212.15	105036.0
2015-04-27 08:30:00	SPY	ETF	212.13	212.16	211.67	212.13	130937.0
2015-04-27 09:00:00	SPY	ETF	212.12	212.41	212.12	212.33	584043.0
2015-04-27 09:30:00	SPY	ETF	212.33	212.43	211.87	212.32	9741692.0
2015-04-27 10:00:00	SPY	ETF	212.34	212.48	212.235	212.33	3754496.0
2015-04-27 10:30:00	SPY	ETF	212.33	212.35	211.81	211.9	4599339.0
2015-04-27 11:00:00	SPY	ETF	211.8901	212.07	211.695	211.97	3777015.0
2015-04-27 11:30:00	SPY	ETF	211.98	212.12	211.65	211.74	3892665.0
2015-04-27 12:00:00	SPY	ETF	211.735	211.81	211.18	211.37	6092225.0
2015-04-27 12:30:00	SPY	ETF	211.37	211.44	211.01	211.17	3356300.0
2015-04-27 13:00:00	SPY	ETF	211.16	211.33	210.92	211.241	3377997.0
2015-04-27 13:30:00	SPY	ETF	211.25	211.4	211.15	211.23	2638719.0
2015-04-27 14:00:00	SPY	ETF	211.23	211.37	210.97	211.31	2865593.0
2015-04-27 14:30:00	SPY	ETF	211.32	211.34	210.89	211.08	3573068.0
2015-04-27 15:00:00	SPY	ETF	211.09	211.25	210.67	210.83	5750338.0
2015-04-27 15:30:00	SPY	ETF	210.83	210.87	210.54	210.76	13699611.0
2015-04-27 16:00:00	SPY	ETF	210.76	211.6261	210.74	211.04	7520363.0
2015-04-27 16:30:00	SPY	ETF	211.04	211.41	210.74	210.84	522967.0
2015-04-27 17:00:00	SPY	ETF	210.85	210.93	210.85	210.87	61768.0
2015-04-27 17:30:00	SPY	ETF	210.89	210.89	210.77	210.82	86278.0
2015-04-27 18:00:00	SPY	ETF	210.87	210.93	210.83	210.88	83615.0
2015-04-27 18:30:00	SPY	ETF	210.89	210.92	210.86	210.92	38900.0
2015-04-27 19:00:00	SPY	ETF	210.92	210.95	210.89	210.91	6125.0
2015-04-27 19:30:00	SPY	ETF	210.93	210.99	210.93	210.98	37033.0
2015-04-27 05:00:00	QQQ	ETF	110.59	110.59	110.59	110.59	1500.0
2015-04-27 06:30:00	QQQ	ETF	110.73	110.73	110.73	110.73	1500.0
2015-04-27 07:00:00	QQQ	ETF	110.71	110.83	110.71	110.77	39119.0
2015-04-27 07:30:00	QQQ	ETF	110.77	110.83	110.76	110.83	94155.0
2015-04-27 08:00:00	QQQ	ETF	110.83	110.92	110.68	110.91	43635.0
2015-04-27 08:30:00	QQQ	ETF	110.9	110.91	110.54	110.91	59435.0
2015-04-27 09:00:00	QQQ	ETF	110.92	111.06	110.92	110.96	321038.0
2015-04-27 09:30:00	QQQ	ETF	110.95	111.13	110.74	111.1	3687579.0
2015-04-27 10:00:00	QQQ	ETF	111.1	111.16	110.9601	111.015	1641599.0
2015-04-27 10:30:00	QQQ	ETF	111.01	111.04	110.7945	110.8	1427637.0
2015-04-27 11:00:00	QQQ	ETF	110.79	110.93	110.6899	110.88	1604283.0
2015-04-27 11:30:00	QQQ	ETF	110.88	110.94	110.59	110.62	1457383.0
2015-04-27 12:00:00	QQQ	ETF	110.62	110.665	110.35	110.54	2405787.0
2015-04-27 12:30:00	QQQ	ETF	110.54	110.575	110.34	110.415	1473742.0
2015-04-27 13:00:00	QQQ	ETF	110.41	110.55	110.32	110.47	1475698.0
2015-04-27 13:30:00	QQQ	ETF	110.48	110.52	110.35	110.35	668081.0
2015-04-27 14:00:00	QQQ	ETF	110.36	110.44	110.19	110.38	1443723.0
2015-04-27 14:30:00	QQQ	ETF	110.39	110.3975	110.15	110.25	1292942.0

> showing 50 of 13,137 rows — these rows as CSV

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