PREVIEW / etf_30min / 2020-11-05

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-05.parquet
  size:    588 KB
  rows:    22,174

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-05 04:00:00	SPY	ETF	347.87	348.15	347.28	347.76	42962.0
2020-11-05 04:30:00	SPY	ETF	347.7	349.05	347.5	349.0	38176.0
2020-11-05 05:00:00	SPY	ETF	349.0	350.37	348.81	349.7	107972.0
2020-11-05 05:30:00	SPY	ETF	349.65	350.66	349.41	350.66	39014.0
2020-11-05 06:00:00	SPY	ETF	350.59	350.77	349.79	350.54	94672.0
2020-11-05 06:30:00	SPY	ETF	350.6	350.6	349.71	349.99	90270.0
2020-11-05 07:00:00	SPY	ETF	349.96	350.0	349.06	349.69	215569.0
2020-11-05 07:30:00	SPY	ETF	349.7	350.3	349.38	350.12	207608.0
2020-11-05 08:00:00	SPY	ETF	350.11	350.64	345.75	349.6	273444.0
2020-11-05 08:30:00	SPY	ETF	349.6	349.92	349.39	349.39	202183.0
2020-11-05 09:00:00	SPY	ETF	349.4	349.57	348.46	349.24	892435.0
2020-11-05 09:30:00	SPY	ETF	349.24	350.71	348.89	349.85	11891145.0
2020-11-05 10:00:00	SPY	ETF	349.85	352.19	349.8	350.86	7322573.0
2020-11-05 10:30:00	SPY	ETF	350.86	351.68	350.7	351.66	4949175.0
2020-11-05 11:00:00	SPY	ETF	351.66	351.918	350.47	351.08	3526428.0
2020-11-05 11:30:00	SPY	ETF	351.1	351.3	350.19	350.27	3264699.0
2020-11-05 12:00:00	SPY	ETF	350.28	350.77	348.86	349.09	4035661.0
2020-11-05 12:30:00	SPY	ETF	349.09	350.51	348.92	350.51	2490404.0
2020-11-05 13:00:00	SPY	ETF	350.51	351.2	350.46	350.8099	3907831.0
2020-11-05 13:30:00	SPY	ETF	350.81	351.37	350.74	351.15	3107922.0
2020-11-05 14:00:00	SPY	ETF	351.15	351.63	350.85	351.4	3408628.0
2020-11-05 14:30:00	SPY	ETF	351.41	352.06	350.9208	351.72	4617433.0
2020-11-05 15:00:00	SPY	ETF	351.72	351.79	350.5312	351.13	4955210.0
2020-11-05 15:30:00	SPY	ETF	351.13	351.16	349.47	350.21	15016833.0
2020-11-05 16:00:00	SPY	ETF	350.2	351.19	350.14	350.95	4571558.0
2020-11-05 16:30:00	SPY	ETF	350.99	351.39	350.76	351.08	296337.0
2020-11-05 17:00:00	SPY	ETF	351.08	351.1	350.8	350.97	38602.0
2020-11-05 17:30:00	SPY	ETF	350.9701	351.09	350.75	350.9	83019.0
2020-11-05 18:00:00	SPY	ETF	350.9	350.9	349.83	349.87	244980.0
2020-11-05 18:30:00	SPY	ETF	349.91	350.05	348.31	349.88	286107.0
2020-11-05 19:00:00	SPY	ETF	349.94	350.11	348.84	348.84	202322.0
2020-11-05 19:30:00	SPY	ETF	348.93	349.47	348.76	348.9	176164.0
2020-11-05 04:00:00	QQQ	ETF	293.36	293.67	292.96	293.43	87913.0
2020-11-05 04:30:00	QQQ	ETF	293.29	294.46	293.05	294.36	106760.0
2020-11-05 05:00:00	QQQ	ETF	294.35	295.41	294.35	294.8	90423.0
2020-11-05 05:30:00	QQQ	ETF	294.78	295.24	294.52	295.17	72727.0
2020-11-05 06:00:00	QQQ	ETF	295.28	295.53	294.8	295.01	133375.0
2020-11-05 06:30:00	QQQ	ETF	295.11	295.11	294.31	294.32	43555.0
2020-11-05 07:00:00	QQQ	ETF	294.31	294.52	293.88	294.17	245781.0
2020-11-05 07:30:00	QQQ	ETF	294.13	294.63	293.76	294.55	197565.0
2020-11-05 08:00:00	QQQ	ETF	293.9948	295.03	290.75	294.28	261163.0
2020-11-05 08:30:00	QQQ	ETF	294.25	294.47	294.0	294.08	371890.0
2020-11-05 09:00:00	QQQ	ETF	294.0	294.15	293.19	293.45	618900.0
2020-11-05 09:30:00	QQQ	ETF	293.44	294.8	292.0	294.29	7451066.0
2020-11-05 10:00:00	QQQ	ETF	294.28	295.32	293.15	293.17	4323372.0
2020-11-05 10:30:00	QQQ	ETF	293.19	294.42	292.83	294.3997	2998148.0
2020-11-05 11:00:00	QQQ	ETF	294.39	294.64	293.21	294.1448	1833332.0
2020-11-05 11:30:00	QQQ	ETF	294.12	294.4	293.1	293.16	2030106.0
2020-11-05 12:00:00	QQQ	ETF	293.17	294.13	292.3	292.53	2848300.0
2020-11-05 12:30:00	QQQ	ETF	292.56	293.55	292.05	293.47	1623228.0

> showing 50 of 22,174 rows — these rows as CSV

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