PREVIEW / etf_1hour / 2021-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-12.parquet
  size:    414 KB
  rows:    14,501

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
2021-04-12 04:00:00	SPY	ETF	410.66	410.68	410.35	410.54	11958.0
2021-04-12 05:00:00	SPY	ETF	410.69	410.95	410.66	410.89	13877.0
2021-04-12 06:00:00	SPY	ETF	410.75	410.94	410.66	410.74	9005.0
2021-04-12 07:00:00	SPY	ETF	410.72	411.17	410.69	410.848	54293.0
2021-04-12 08:00:00	SPY	ETF	410.9	411.16	410.46	410.96	108756.0
2021-04-12 09:00:00	SPY	ETF	410.99	411.49	410.45	410.88	4543484.0
2021-04-12 10:00:00	SPY	ETF	410.87	411.21	410.2	410.7439	6415039.0
2021-04-12 11:00:00	SPY	ETF	410.75	411.2	410.6	411.14	4392274.0
2021-04-12 12:00:00	SPY	ETF	411.15	411.79	410.81	411.65	3737067.0
2021-04-12 13:00:00	SPY	ETF	411.65	411.74	410.61	410.73	4500174.0
2021-04-12 14:00:00	SPY	ETF	410.74	411.13	410.635	410.84	3970645.0
2021-04-12 15:00:00	SPY	ETF	410.84	411.93	410.52	411.62	12611175.0
2021-04-12 16:00:00	SPY	ETF	411.62	412.0	411.2197	411.78	1900503.0
2021-04-12 17:00:00	SPY	ETF	411.77	411.77	411.65	411.77	48205.0
2021-04-12 18:00:00	SPY	ETF	411.77	411.82	411.6	411.62	45637.0
2021-04-12 19:00:00	SPY	ETF	411.59	411.87	411.47	411.67	45793.0
2021-04-12 04:00:00	QQQ	ETF	337.0	337.0	336.4	336.4	34322.0
2021-04-12 05:00:00	QQQ	ETF	336.57	336.87	336.45	336.76	19521.0
2021-04-12 06:00:00	QQQ	ETF	336.57	336.68	335.83	335.88	62385.0
2021-04-12 07:00:00	QQQ	ETF	335.9	336.45	335.87	336.12	127162.0
2021-04-12 08:00:00	QQQ	ETF	336.16	336.76	335.88	336.28	116579.0
2021-04-12 09:00:00	QQQ	ETF	336.28	336.63	335.0	335.6002	3506515.0
2021-04-12 10:00:00	QQQ	ETF	335.6	336.52	334.73	335.7109	4013640.0
2021-04-12 11:00:00	QQQ	ETF	335.72	336.2	335.2818	335.95	2535528.0
2021-04-12 12:00:00	QQQ	ETF	335.9592	336.84	335.47	336.79	2016843.0
2021-04-12 13:00:00	QQQ	ETF	336.815	337.1	335.855	335.98	1957188.0
2021-04-12 14:00:00	QQQ	ETF	335.96	336.5982	335.7916	335.9818	1599454.0
2021-04-12 15:00:00	QQQ	ETF	335.98	337.04	335.62	336.68	3469393.0
2021-04-12 16:00:00	QQQ	ETF	336.68	337.0	336.6	336.99	596487.0
2021-04-12 17:00:00	QQQ	ETF	336.93	337.04	336.78	336.78	35409.0
2021-04-12 18:00:00	QQQ	ETF	336.83	337.14	336.71	336.71	56561.0
2021-04-12 19:00:00	QQQ	ETF	336.75	337.0	336.65	336.82	43941.0
2021-04-12 04:00:00	IWM	ETF	221.75	221.81	221.64	221.74	3060.0
2021-04-12 05:00:00	IWM	ETF	221.88	222.11	221.85	222.02	3354.0
2021-04-12 06:00:00	IWM	ETF	222.06	222.25	221.99	222.2	4904.0
2021-04-12 07:00:00	IWM	ETF	222.23	222.61	222.18	222.53	14259.0
2021-04-12 08:00:00	IWM	ETF	222.22	222.58	221.34	222.24	78391.0
2021-04-12 09:00:00	IWM	ETF	222.33	222.93	220.4	220.51	2994602.0
2021-04-12 10:00:00	IWM	ETF	220.537	221.39	220.44	220.945	4018534.0
2021-04-12 11:00:00	IWM	ETF	220.95	221.9	220.5	221.77	1536424.0
2021-04-12 12:00:00	IWM	ETF	221.77	222.62	221.6	222.33	1295098.0
2021-04-12 13:00:00	IWM	ETF	222.35	222.5399	221.6	221.65	1152668.0
2021-04-12 14:00:00	IWM	ETF	221.66	221.8199	221.32	221.545	1024240.0
2021-04-12 15:00:00	IWM	ETF	221.54	222.125	221.22	221.72	2574138.0
2021-04-12 16:00:00	IWM	ETF	221.72	222.09	221.45	221.65	951858.0
2021-04-12 17:00:00	IWM	ETF	221.72	221.89	221.55	221.57	52787.0
2021-04-12 18:00:00	IWM	ETF	221.65	221.65	221.45	221.54	13052.0
2021-04-12 19:00:00	IWM	ETF	221.54	221.65	221.4	221.47	9796.0
2021-04-12 04:00:00	DIA	ETF	336.88	337.06	336.76	337.06	1735.0
2021-04-12 05:00:00	DIA	ETF	337.03	337.16	337.03	337.06	425.0

> showing 50 of 14,501 rows — these rows as CSV

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