PREVIEW / etf_30min / 2020-11-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-11.parquet
  size:    582 KB
  rows:    21,304

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
2020-11-11 04:00:00	SPY	ETF	356.48	356.73	355.85	356.26	54396.0
2020-11-11 04:30:00	SPY	ETF	356.1	356.63	356.0	356.24	31218.0
2020-11-11 05:00:00	SPY	ETF	356.34	356.7	356.24	356.7	72474.0
2020-11-11 05:30:00	SPY	ETF	356.62	356.72	356.41	356.6	14682.0
2020-11-11 06:00:00	SPY	ETF	356.51	357.16	356.47	357.12	43911.0
2020-11-11 06:30:00	SPY	ETF	357.16	357.16	356.73	357.0	34492.0
2020-11-11 07:00:00	SPY	ETF	357.0	357.17	356.34	356.89	85152.0
2020-11-11 07:30:00	SPY	ETF	356.95	357.0	356.59	356.9	64804.0
2020-11-11 08:00:00	SPY	ETF	357.0001	357.25	354.5	356.91	439384.0
2020-11-11 08:30:00	SPY	ETF	356.9	356.95	356.21	356.47	343948.0
2020-11-11 09:00:00	SPY	ETF	356.47	356.56	356.12	356.4	199295.0
2020-11-11 09:30:00	SPY	ETF	356.4	356.6	355.12	355.2978	5976375.0
2020-11-11 10:00:00	SPY	ETF	355.31	355.87	355.12	355.85	3340481.0
2020-11-11 10:30:00	SPY	ETF	355.87	356.31	355.47	356.0	2865261.0
2020-11-11 11:00:00	SPY	ETF	355.98	356.74	355.78	356.62	2455958.0
2020-11-11 11:30:00	SPY	ETF	356.63	356.94	356.46	356.9	3561761.0
2020-11-11 12:00:00	SPY	ETF	356.91	357.36	356.72	356.88	2132324.0
2020-11-11 12:30:00	SPY	ETF	356.89	357.35	356.87	357.1	1454645.0
2020-11-11 13:00:00	SPY	ETF	357.11	357.56	356.92	357.02	1847967.0
2020-11-11 13:30:00	SPY	ETF	357.03	357.44	356.64	356.7	2121414.0
2020-11-11 14:00:00	SPY	ETF	356.71	357.28	356.165	356.29	3016684.0
2020-11-11 14:30:00	SPY	ETF	356.286	356.55	355.06	355.71	4819533.0
2020-11-11 15:00:00	SPY	ETF	355.73	356.25	355.39	355.4	3701941.0
2020-11-11 15:30:00	SPY	ETF	355.4	356.89	355.32	356.62	8698534.0
2020-11-11 16:00:00	SPY	ETF	356.64	357.29	356.64	357.28	8081139.0
2020-11-11 16:30:00	SPY	ETF	357.22	357.52	357.14	357.24	212102.0
2020-11-11 17:00:00	SPY	ETF	357.28	357.39	357.17	357.33	251003.0
2020-11-11 17:30:00	SPY	ETF	357.37	357.42	357.28	357.39	37865.0
2020-11-11 18:00:00	SPY	ETF	357.36	357.36	356.85	357.13	133291.0
2020-11-11 18:30:00	SPY	ETF	357.15	357.34	356.7	356.82	133399.0
2020-11-11 19:00:00	SPY	ETF	356.73	356.89	356.38	356.68	117162.0
2020-11-11 19:30:00	SPY	ETF	356.59	357.06	356.45	356.58	52292.0
2020-11-11 04:00:00	QQQ	ETF	286.46	286.66	285.69	285.95	61142.0
2020-11-11 04:30:00	QQQ	ETF	285.94	286.52	285.6	286.19	19722.0
2020-11-11 05:00:00	QQQ	ETF	286.23	286.48	286.0	286.11	24035.0
2020-11-11 05:30:00	QQQ	ETF	286.07	286.65	285.78	286.49	15889.0
2020-11-11 06:00:00	QQQ	ETF	286.37	287.21	286.31	286.73	34582.0
2020-11-11 06:30:00	QQQ	ETF	286.8	286.8	286.01	286.6	34548.0
2020-11-11 07:00:00	QQQ	ETF	286.52	286.86	285.79	286.46	177975.0
2020-11-11 07:30:00	QQQ	ETF	286.43	287.06	286.43	286.86	101309.0
2020-11-11 08:00:00	QQQ	ETF	286.86	287.45	282.73	286.87	302799.0
2020-11-11 08:30:00	QQQ	ETF	286.88	286.9	285.9	286.23	228069.0
2020-11-11 09:00:00	QQQ	ETF	286.2	286.3	285.76	285.86	246849.0
2020-11-11 09:30:00	QQQ	ETF	285.92	288.55	285.53	287.5	5191670.0
2020-11-11 10:00:00	QQQ	ETF	287.53	288.5	287.32	288.43	2544443.0
2020-11-11 10:30:00	QQQ	ETF	288.44	288.89	287.25	288.015	1967280.0
2020-11-11 11:00:00	QQQ	ETF	288.0	288.72	287.4	288.36	1446667.0
2020-11-11 11:30:00	QQQ	ETF	288.37	289.4018	288.11	289.4	1413034.0
2020-11-11 12:00:00	QQQ	ETF	289.39	289.96	289.1064	289.38	1029704.0
2020-11-11 12:30:00	QQQ	ETF	289.38	289.83	289.05	289.23	805601.0

> showing 50 of 21,304 rows — these rows as CSV

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