PREVIEW / etf_30min / 2016-10-13

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-10-13.parquet
  size:    410 KB
  rows:    13,843

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
2016-10-13 04:00:00	SPY	ETF	211.94	212.13	211.75	211.98	158069.0
2016-10-13 04:30:00	SPY	ETF	211.96	212.3	211.94	212.28	26954.0
2016-10-13 05:00:00	SPY	ETF	212.29	212.39	212.28	212.31	7174.0
2016-10-13 05:30:00	SPY	ETF	212.36	212.54	212.3	212.31	20881.0
2016-10-13 06:00:00	SPY	ETF	212.29	212.34	212.2	212.34	9517.0
2016-10-13 06:30:00	SPY	ETF	212.26	212.42	212.26	212.38	13718.0
2016-10-13 07:00:00	SPY	ETF	212.39	212.47	212.31	212.31	273089.0
2016-10-13 07:30:00	SPY	ETF	212.31	212.45	212.18	212.42	398421.0
2016-10-13 08:00:00	SPY	ETF	212.41	213.71	212.09	212.14	301125.0
2016-10-13 08:30:00	SPY	ETF	212.14	212.24	211.89	212.06	672056.0
2016-10-13 09:00:00	SPY	ETF	212.09	212.4	212.08	212.17	1258300.0
2016-10-13 09:30:00	SPY	ETF	212.16	212.31	211.27	211.48	15865321.0
2016-10-13 10:00:00	SPY	ETF	211.475	211.73	211.21	211.56	9565369.0
2016-10-13 10:30:00	SPY	ETF	211.56	212.105	211.35	211.935	9197358.0
2016-10-13 11:00:00	SPY	ETF	211.94	212.35	211.51	212.225	8136799.0
2016-10-13 11:30:00	SPY	ETF	212.21	212.47	212.18	212.25	6261251.0
2016-10-13 12:00:00	SPY	ETF	212.25	212.47	212.08	212.34	3017369.0
2016-10-13 12:30:00	SPY	ETF	212.33	212.91	212.31	212.78	4952848.0
2016-10-13 13:00:00	SPY	ETF	212.775	212.79	212.47	212.6811	3912559.0
2016-10-13 13:30:00	SPY	ETF	212.67	213.23	212.54	213.2101	3803448.0
2016-10-13 14:00:00	SPY	ETF	213.215	213.38	213.05	213.21	4117198.0
2016-10-13 14:30:00	SPY	ETF	213.21	213.59	213.11	213.495	4753072.0
2016-10-13 15:00:00	SPY	ETF	213.499	213.59	213.21	213.24	4414925.0
2016-10-13 15:30:00	SPY	ETF	213.24	213.35	212.78	213.04	11599832.0
2016-10-13 16:00:00	SPY	ETF	213.03	213.12	212.3984	212.97	6032390.0
2016-10-13 16:30:00	SPY	ETF	212.98	213.01	212.92	212.98	355861.0
2016-10-13 17:00:00	SPY	ETF	212.96	213.01	212.89	212.98	112426.0
2016-10-13 17:30:00	SPY	ETF	212.99	213.04	212.99	213.03	85404.0
2016-10-13 18:00:00	SPY	ETF	213.02	213.04	212.88	212.94	101087.0
2016-10-13 18:30:00	SPY	ETF	212.95	212.99	212.92	212.99	7207.0
2016-10-13 19:00:00	SPY	ETF	212.96	213.07	212.96	213.04	7429.0
2016-10-13 19:30:00	SPY	ETF	213.02	213.06	212.9	212.93	20005.0
2016-10-13 04:00:00	QQQ	ETF	116.61	116.63	116.55	116.56	96450.0
2016-10-13 04:30:00	QQQ	ETF	116.55	116.68	116.55	116.68	11596.0
2016-10-13 05:00:00	QQQ	ETF	116.7	116.76	116.7	116.7	1032.0
2016-10-13 05:30:00	QQQ	ETF	116.75	116.76	116.65	116.65	6698.0
2016-10-13 06:00:00	QQQ	ETF	116.7	116.71	116.65	116.66	3800.0
2016-10-13 06:30:00	QQQ	ETF	116.7	116.73	116.68	116.72	4100.0
2016-10-13 07:00:00	QQQ	ETF	116.72	116.76	116.69	116.69	58063.0
2016-10-13 07:30:00	QQQ	ETF	116.69	116.75	116.63	116.71	28925.0
2016-10-13 08:00:00	QQQ	ETF	116.72	116.74	116.59	116.6	91143.0
2016-10-13 08:30:00	QQQ	ETF	116.62	116.66	116.48	116.61	137022.0
2016-10-13 09:00:00	QQQ	ETF	116.65	116.72	116.59	116.64	141921.0
2016-10-13 09:30:00	QQQ	ETF	116.635	116.66	115.97	116.11	4735525.0
2016-10-13 10:00:00	QQQ	ETF	116.11	116.29	115.94	116.165	1989737.0
2016-10-13 10:30:00	QQQ	ETF	116.17	116.49	116.01	116.31	1062114.0
2016-10-13 11:00:00	QQQ	ETF	116.318	116.6	116.1	116.55	1539577.0
2016-10-13 11:30:00	QQQ	ETF	116.5555	116.69	116.55	116.649	867037.0
2016-10-13 12:00:00	QQQ	ETF	116.64	116.71	116.54	116.6	631760.0
2016-10-13 12:30:00	QQQ	ETF	116.59	116.97	116.58	116.87	1285626.0

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

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