PREVIEW / etf_30min / 2015-06-19

all etf 30-min files

  file:    by_date/etf_30min/2015/2015-06-19.parquet
  size:    370 KB
  rows:    12,465

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-19 04:00:00	SPY	ETF	212.05	212.19	211.7	211.99	31993.0
2015-06-19 04:30:00	SPY	ETF	212.09	212.09	211.86	211.94	7100.0
2015-06-19 05:00:00	SPY	ETF	211.92	212.09	211.88	212.09	2300.0
2015-06-19 05:30:00	SPY	ETF	212.16	212.16	212.01	212.01	7800.0
2015-06-19 06:00:00	SPY	ETF	212.06	212.08	212.05	212.08	497.0
2015-06-19 06:30:00	SPY	ETF	212.08	212.1	211.95	212.09	14700.0
2015-06-19 07:00:00	SPY	ETF	212.1	212.17	212.0	212.0	188974.0
2015-06-19 07:30:00	SPY	ETF	212.0	212.08	211.95	212.08	194663.0
2015-06-19 08:00:00	SPY	ETF	212.09	212.1	211.98	212.09	237308.0
2015-06-19 08:30:00	SPY	ETF	212.09	212.09	211.75	211.78	671474.0
2015-06-19 09:00:00	SPY	ETF	211.77	211.77	211.41	211.46	3062147.0
2015-06-19 09:30:00	SPY	ETF	211.46	211.52	211.09	211.35	20241776.0
2015-06-19 10:00:00	SPY	ETF	211.35	211.55	211.32	211.46	7143438.0
2015-06-19 10:30:00	SPY	ETF	211.46	211.54	211.26	211.51	8691511.0
2015-06-19 11:00:00	SPY	ETF	211.51	211.52	211.33	211.42	6908225.0
2015-06-19 11:30:00	SPY	ETF	211.43	211.45	211.07	211.13	4517550.0
2015-06-19 12:00:00	SPY	ETF	211.135	211.1598	210.985	211.02	5524528.0
2015-06-19 12:30:00	SPY	ETF	211.02	211.18	210.95	211.114	3566643.0
2015-06-19 13:00:00	SPY	ETF	211.12	211.16	210.99	211.105	4598718.0
2015-06-19 13:30:00	SPY	ETF	211.105	211.31	211.1	211.21	3245906.0
2015-06-19 14:00:00	SPY	ETF	211.205	211.225	210.76	210.88	6601031.0
2015-06-19 14:30:00	SPY	ETF	210.87	210.92	210.68	210.77	4694286.0
2015-06-19 15:00:00	SPY	ETF	210.765	210.8	210.57	210.63	6972465.0
2015-06-19 15:30:00	SPY	ETF	210.62	211.01	210.44	210.45	18495143.0
2015-06-19 16:00:00	SPY	ETF	210.46	211.488	210.19	210.24	15552950.0
2015-06-19 16:30:00	SPY	ETF	210.24	210.81	210.18	210.46	2961484.0
2015-06-19 17:00:00	SPY	ETF	210.49	210.81	210.18	210.3	494001.0
2015-06-19 17:30:00	SPY	ETF	210.33	210.37	210.23	210.35	99502.0
2015-06-19 18:00:00	SPY	ETF	210.35	210.42	210.31	210.42	50380.0
2015-06-19 18:30:00	SPY	ETF	210.4	210.81	210.4	210.55	90002.0
2015-06-19 19:00:00	SPY	ETF	210.56	210.6	210.5	210.5	6728.0
2015-06-19 19:30:00	SPY	ETF	210.46	210.57	210.39	210.57	59472.0
2015-06-19 04:00:00	QQQ	ETF	110.6	110.6	110.6	110.6	200.0
2015-06-19 07:00:00	QQQ	ETF	110.67	110.72	110.67	110.7	3000.0
2015-06-19 07:30:00	QQQ	ETF	110.7	110.72	110.64	110.72	11960.0
2015-06-19 08:00:00	QQQ	ETF	110.66	110.72	110.65	110.71	19470.0
2015-06-19 08:30:00	QQQ	ETF	110.7	110.71	110.58	110.6	42154.0
2015-06-19 09:00:00	QQQ	ETF	110.6	110.63	110.43	110.5	358916.0
2015-06-19 09:30:00	QQQ	ETF	110.51	110.575	110.05	110.14	3038521.0
2015-06-19 10:00:00	QQQ	ETF	110.14	110.25	110.11	110.165	1183783.0
2015-06-19 10:30:00	QQQ	ETF	110.17	110.26	110.03	110.25	1148209.0
2015-06-19 11:00:00	QQQ	ETF	110.25	110.34	110.155	110.31	950577.0
2015-06-19 11:30:00	QQQ	ETF	110.31	110.329	110.05	110.079	858024.0
2015-06-19 12:00:00	QQQ	ETF	110.07	110.105	109.96	110.01	1210788.0
2015-06-19 12:30:00	QQQ	ETF	110.01	110.1	109.95	110.099	1372992.0
2015-06-19 13:00:00	QQQ	ETF	110.1	110.13	110.05	110.11	738061.0
2015-06-19 13:30:00	QQQ	ETF	110.11	110.23	110.1	110.188	695435.0
2015-06-19 14:00:00	QQQ	ETF	110.19	110.21	109.99	110.03	948629.0
2015-06-19 14:30:00	QQQ	ETF	110.02	110.09	109.93	109.98	839985.0
2015-06-19 15:00:00	QQQ	ETF	109.98	110.03	109.88	109.95	1122940.0

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

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