PREVIEW / etf_30min / 2018-04-26

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-04-26.parquet
  size:    457 KB
  rows:    15,644

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
2018-04-26 04:00:00	SPY	ETF	263.94	264.22	263.93	264.11	13807.0
2018-04-26 04:30:00	SPY	ETF	264.0	264.14	263.99	264.12	4764.0
2018-04-26 05:00:00	SPY	ETF	264.1	264.37	264.02	264.36	5458.0
2018-04-26 05:30:00	SPY	ETF	264.35	264.61	264.34	264.57	6260.0
2018-04-26 06:00:00	SPY	ETF	264.59	264.75	264.45	264.63	74766.0
2018-04-26 06:30:00	SPY	ETF	264.61	264.89	264.6	264.84	35356.0
2018-04-26 07:00:00	SPY	ETF	264.84	264.88	264.7	264.77	112910.0
2018-04-26 07:30:00	SPY	ETF	264.75	265.14	264.63	264.95	105302.0
2018-04-26 08:00:00	SPY	ETF	264.6899	265.09	263.75	264.96	143096.0
2018-04-26 08:30:00	SPY	ETF	264.91	265.13	264.8	265.12	188052.0
2018-04-26 09:00:00	SPY	ETF	265.1	265.14	264.71	264.81	402052.0
2018-04-26 09:30:00	SPY	ETF	264.79	265.06	264.29	264.96	7670911.0
2018-04-26 10:00:00	SPY	ETF	264.96	265.65	264.77	265.32	5708246.0
2018-04-26 10:30:00	SPY	ETF	265.32	266.03	265.3	265.99	3973673.0
2018-04-26 11:00:00	SPY	ETF	265.98	266.02	265.28	265.49	3775742.0
2018-04-26 11:30:00	SPY	ETF	265.48	265.59	264.94	265.32	3156149.0
2018-04-26 12:00:00	SPY	ETF	265.33	265.97	265.2906	265.83	2116093.0
2018-04-26 12:30:00	SPY	ETF	265.835	265.88	265.47	265.76	1819761.0
2018-04-26 13:00:00	SPY	ETF	265.761	266.57	265.76	266.4	3359800.0
2018-04-26 13:30:00	SPY	ETF	266.42	266.65	266.25	266.63	3090974.0
2018-04-26 14:00:00	SPY	ETF	266.64	266.8	266.43	266.63	3615219.0
2018-04-26 14:30:00	SPY	ETF	266.6392	267.16	266.57	267.0011	3518770.0
2018-04-26 15:00:00	SPY	ETF	267.01	267.2452	266.37	266.45	4596758.0
2018-04-26 15:30:00	SPY	ETF	266.46	266.67	266.08	266.31	11122610.0
2018-04-26 16:00:00	SPY	ETF	266.31	267.29	266.16	267.2	6874741.0
2018-04-26 16:30:00	SPY	ETF	267.2	267.43	266.31	267.0	843825.0
2018-04-26 17:00:00	SPY	ETF	266.93	267.09	266.8	266.93	98072.0
2018-04-26 17:30:00	SPY	ETF	266.94	267.17	266.94	267.12	21531.0
2018-04-26 18:00:00	SPY	ETF	267.18	267.27	266.95	267.0	176475.0
2018-04-26 18:30:00	SPY	ETF	267.03	267.03	266.9	267.01	48117.0
2018-04-26 19:00:00	SPY	ETF	267.02	267.13	266.94	266.99	12093.0
2018-04-26 19:30:00	SPY	ETF	267.01	267.01	266.89	266.91	40823.0
2018-04-26 04:00:00	QQQ	ETF	160.0	160.25	159.84	159.97	43543.0
2018-04-26 04:30:00	QQQ	ETF	159.88	160.05	159.88	159.99	8411.0
2018-04-26 05:00:00	QQQ	ETF	159.97	160.26	159.92	160.22	6600.0
2018-04-26 05:30:00	QQQ	ETF	160.25	160.45	160.24	160.4	4800.0
2018-04-26 06:00:00	QQQ	ETF	160.36	160.46	160.24	160.42	10300.0
2018-04-26 06:30:00	QQQ	ETF	160.41	160.55	160.37	160.5	8100.0
2018-04-26 07:00:00	QQQ	ETF	160.48	160.6	160.42	160.45	50814.0
2018-04-26 07:30:00	QQQ	ETF	160.41	160.71	160.25	160.53	60012.0
2018-04-26 08:00:00	QQQ	ETF	160.57	160.8	160.37	160.68	100706.0
2018-04-26 08:30:00	QQQ	ETF	160.66	160.96	160.6	160.96	171635.0
2018-04-26 09:00:00	QQQ	ETF	160.97	161.04	160.7	160.73	250009.0
2018-04-26 09:30:00	QQQ	ETF	160.72	160.99	160.18	160.83	5773903.0
2018-04-26 10:00:00	QQQ	ETF	160.83	161.6735	160.67	161.46	3865978.0
2018-04-26 10:30:00	QQQ	ETF	161.47	161.7	161.16	161.66	2207346.0
2018-04-26 11:00:00	QQQ	ETF	161.66	161.77	161.26	161.52	2002136.0
2018-04-26 11:30:00	QQQ	ETF	161.5	161.61	161.05	161.22	1413083.0
2018-04-26 12:00:00	QQQ	ETF	161.21	161.76	161.21	161.64	1492199.0
2018-04-26 12:30:00	QQQ	ETF	161.65	161.76	161.42	161.52	1093963.0

> showing 50 of 15,644 rows — these rows as CSV

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