PREVIEW / etf_30min / 2017-03-31

all etf 30-min files

  file:    by_date/etf_30min/2017/2017-03-31.parquet
  size:    421 KB
  rows:    14,431

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
2017-03-31 04:00:00	SPY	ETF	235.76	235.76	235.62	235.63	13415.0
2017-03-31 04:30:00	SPY	ETF	235.7	235.7	235.6	235.6	2960.0
2017-03-31 05:00:00	SPY	ETF	235.61	235.75	235.61	235.72	1920.0
2017-03-31 05:30:00	SPY	ETF	235.75	235.82	235.69	235.69	2009.0
2017-03-31 06:00:00	SPY	ETF	235.74	235.74	235.64	235.71	34386.0
2017-03-31 06:30:00	SPY	ETF	235.71	235.72	235.62	235.68	120428.0
2017-03-31 07:00:00	SPY	ETF	235.72	235.8	235.69	235.76	32467.0
2017-03-31 07:30:00	SPY	ETF	235.76	235.86	235.76	235.85	116987.0
2017-03-31 08:00:00	SPY	ETF	235.7	236.08	235.69	236.03	357714.0
2017-03-31 08:30:00	SPY	ETF	236.02	236.13	235.95	236.0	147730.0
2017-03-31 09:00:00	SPY	ETF	236.0	236.08	235.89	235.91	342249.0
2017-03-31 09:30:00	SPY	ETF	235.9	236.14	235.72	236.0495	6000132.0
2017-03-31 10:00:00	SPY	ETF	236.04	236.33	235.9	235.96	4323967.0
2017-03-31 10:30:00	SPY	ETF	235.96	236.36	235.96	236.1301	2821859.0
2017-03-31 11:00:00	SPY	ETF	236.14	236.32	236.05	236.24	3060034.0
2017-03-31 11:30:00	SPY	ETF	236.24	236.36	236.12	236.17	1617537.0
2017-03-31 12:00:00	SPY	ETF	236.16	236.39	236.13	236.365	2049773.0
2017-03-31 12:30:00	SPY	ETF	236.37	236.39	236.18	236.265	1408008.0
2017-03-31 13:00:00	SPY	ETF	236.26	236.47	236.18	236.47	1269530.0
2017-03-31 13:30:00	SPY	ETF	236.46	236.51	236.16	236.16	2765998.0
2017-03-31 14:00:00	SPY	ETF	236.165	236.2	235.795	235.9737	4465885.0
2017-03-31 14:30:00	SPY	ETF	235.98	236.12	235.9	235.9001	3007971.0
2017-03-31 15:00:00	SPY	ETF	235.91	236.2673	235.9	236.16	4936178.0
2017-03-31 15:30:00	SPY	ETF	236.15	236.47	235.68	235.71	15800468.0
2017-03-31 16:00:00	SPY	ETF	235.7	235.93	235.64	235.69	15030117.0
2017-03-31 16:30:00	SPY	ETF	235.72	236.2644	235.6	235.63	1516161.0
2017-03-31 17:00:00	SPY	ETF	235.74	235.74	235.53	235.6	484979.0
2017-03-31 17:30:00	SPY	ETF	235.59	235.74	235.49	235.53	229099.0
2017-03-31 18:00:00	SPY	ETF	235.54	235.84	235.53	235.75	99594.0
2017-03-31 18:30:00	SPY	ETF	235.74	235.75	235.58	235.58	25067.0
2017-03-31 19:00:00	SPY	ETF	235.6	235.61	235.58	235.58	4068.0
2017-03-31 19:30:00	SPY	ETF	235.6	235.65	235.58	235.65	16483.0
2017-03-31 04:00:00	QQQ	ETF	132.11	132.11	132.11	132.11	338.0
2017-03-31 05:00:00	QQQ	ETF	132.08	132.09	132.05	132.05	3500.0
2017-03-31 05:30:00	QQQ	ETF	132.14	132.23	132.14	132.23	15600.0
2017-03-31 06:00:00	QQQ	ETF	132.18	132.18	132.14	132.16	9811.0
2017-03-31 06:30:00	QQQ	ETF	132.16	132.16	132.16	132.16	5100.0
2017-03-31 07:00:00	QQQ	ETF	132.17	132.18	132.17	132.18	6903.0
2017-03-31 07:30:00	QQQ	ETF	132.21	132.23	132.19	132.23	13396.0
2017-03-31 08:00:00	QQQ	ETF	132.22	132.34	132.22	132.34	42217.0
2017-03-31 08:30:00	QQQ	ETF	132.3	132.37	132.29	132.31	16128.0
2017-03-31 09:00:00	QQQ	ETF	132.3	132.37	132.27	132.27	40738.0
2017-03-31 09:30:00	QQQ	ETF	132.27	132.42	132.125	132.33	1432513.0
2017-03-31 10:00:00	QQQ	ETF	132.34	132.54	132.33	132.37	1437782.0
2017-03-31 10:30:00	QQQ	ETF	132.36	132.55	132.36	132.465	1112216.0
2017-03-31 11:00:00	QQQ	ETF	132.46	132.625	132.45	132.55	575875.0
2017-03-31 11:30:00	QQQ	ETF	132.55	132.61	132.49	132.52	1064452.0
2017-03-31 12:00:00	QQQ	ETF	132.523	132.67	132.515	132.6557	417939.0
2017-03-31 12:30:00	QQQ	ETF	132.66	132.67	132.585	132.62	519928.0
2017-03-31 13:00:00	QQQ	ETF	132.62	132.71	132.6	132.71	614169.0

> showing 50 of 14,431 rows — these rows as CSV

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