PREVIEW / etf_30min / 2018-11-29

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-29.parquet
  size:    487 KB
  rows:    16,866

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-11-29 04:00:00	SPY	ETF	273.83	273.83	273.36	273.67	21726.0
2018-11-29 04:30:00	SPY	ETF	273.69	273.86	273.49	273.51	10358.0
2018-11-29 05:00:00	SPY	ETF	273.41	273.69	273.41	273.69	6900.0
2018-11-29 05:30:00	SPY	ETF	273.66	273.67	273.23	273.25	79302.0
2018-11-29 06:00:00	SPY	ETF	273.33	273.49	273.3	273.43	16350.0
2018-11-29 06:30:00	SPY	ETF	273.29	273.48	273.01	273.29	49668.0
2018-11-29 07:00:00	SPY	ETF	273.3	273.74	273.28	273.7	148732.0
2018-11-29 07:30:00	SPY	ETF	273.7	273.78	273.31	273.38	154894.0
2018-11-29 08:00:00	SPY	ETF	273.26	273.71	273.26	273.6	198536.0
2018-11-29 08:30:00	SPY	ETF	273.67	273.89	273.55	273.63	686428.0
2018-11-29 09:00:00	SPY	ETF	273.62	273.84	273.46	273.72	292958.0
2018-11-29 09:30:00	SPY	ETF	273.71	274.02	273.46	273.64	6328846.0
2018-11-29 10:00:00	SPY	ETF	273.63	273.82	273.03	273.05	4874898.0
2018-11-29 10:30:00	SPY	ETF	273.06	274.12	272.43	272.79	9157162.0
2018-11-29 11:00:00	SPY	ETF	272.79	273.51	272.57	273.49	6871232.0
2018-11-29 11:30:00	SPY	ETF	273.49	274.0	273.19	273.92	4997222.0
2018-11-29 12:00:00	SPY	ETF	273.92	273.94	273.41	273.85	2947812.0
2018-11-29 12:30:00	SPY	ETF	273.84	274.3185	273.8	274.26	2341044.0
2018-11-29 13:00:00	SPY	ETF	274.26	274.29	273.82	274.04	2475006.0
2018-11-29 13:30:00	SPY	ETF	274.036	274.45	273.91	274.15	2226046.0
2018-11-29 14:00:00	SPY	ETF	274.17	275.05	273.92	274.84	5625414.0
2018-11-29 14:30:00	SPY	ETF	274.83	275.54	274.73	275.49	3862864.0
2018-11-29 15:00:00	SPY	ETF	275.49	275.55	274.79	275.0239	4525252.0
2018-11-29 15:30:00	SPY	ETF	275.02	275.02	273.83	273.96	13178896.0
2018-11-29 16:00:00	SPY	ETF	273.95	274.55	273.85	274.38	8605314.0
2018-11-29 16:30:00	SPY	ETF	274.38	274.44	273.85	274.27	470969.0
2018-11-29 17:00:00	SPY	ETF	274.28	274.38	274.18	274.37	124070.0
2018-11-29 17:30:00	SPY	ETF	274.38	274.6	274.31	274.31	359393.0
2018-11-29 18:00:00	SPY	ETF	274.29	274.3	273.95	274.0	329038.0
2018-11-29 18:30:00	SPY	ETF	274.01	274.14	273.87	274.14	59037.0
2018-11-29 19:00:00	SPY	ETF	274.13	274.25	273.93	274.14	42943.0
2018-11-29 19:30:00	SPY	ETF	274.18	274.25	274.13	274.16	30607.0
2018-11-29 04:00:00	QQQ	ETF	168.33	168.33	167.7	167.86	50344.0
2018-11-29 04:30:00	QQQ	ETF	167.88	167.96	167.77	167.83	14973.0
2018-11-29 05:00:00	QQQ	ETF	167.71	167.85	167.7	167.85	8795.0
2018-11-29 05:30:00	QQQ	ETF	167.88	167.95	167.51	167.59	28586.0
2018-11-29 06:00:00	QQQ	ETF	167.56	167.69	167.56	167.64	18748.0
2018-11-29 06:30:00	QQQ	ETF	167.63	167.66	167.41	167.51	40594.0
2018-11-29 07:00:00	QQQ	ETF	167.52	167.96	167.5	167.89	50530.0
2018-11-29 07:30:00	QQQ	ETF	167.88	167.97	167.61	167.63	65746.0
2018-11-29 08:00:00	QQQ	ETF	167.7401	167.88	167.51	167.87	87426.0
2018-11-29 08:30:00	QQQ	ETF	167.89	168.15	167.88	167.91	361366.0
2018-11-29 09:00:00	QQQ	ETF	167.89	168.03	167.78	168.03	258135.0
2018-11-29 09:30:00	QQQ	ETF	168.02	168.469	167.59	168.04	3706945.0
2018-11-29 10:00:00	QQQ	ETF	168.05	168.27	167.28	167.35	3196278.0
2018-11-29 10:30:00	QQQ	ETF	167.36	168.165	166.82	166.985	4861727.0
2018-11-29 11:00:00	QQQ	ETF	166.98	167.64	166.8899	167.63	4363516.0
2018-11-29 11:30:00	QQQ	ETF	167.62	168.15	167.4385	168.0	1994451.0
2018-11-29 12:00:00	QQQ	ETF	168.0	168.02	167.6	167.9899	1330491.0
2018-11-29 12:30:00	QQQ	ETF	167.99	168.38	167.85	168.36	957139.0

> showing 50 of 16,866 rows — these rows as CSV

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