PREVIEW / etf_1hour / 2021-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-01.parquet
  size:    435 KB
  rows:    15,020

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-01 04:00:00	SPY	ETF	397.73	397.93	396.84	397.92	30363.0
2021-04-01 05:00:00	SPY	ETF	397.92	398.0	397.6	397.71	25342.0
2021-04-01 06:00:00	SPY	ETF	397.62	397.62	397.29	397.31	72166.0
2021-04-01 07:00:00	SPY	ETF	397.24	397.95	397.24	397.89	135041.0
2021-04-01 08:00:00	SPY	ETF	397.5804	398.2	396.33	398.11	223668.0
2021-04-01 09:00:00	SPY	ETF	398.13	398.77	396.33	398.41	7862365.0
2021-04-01 10:00:00	SPY	ETF	398.41	399.32	398.24	399.3081	9023913.0
2021-04-01 11:00:00	SPY	ETF	399.3	399.64	399.02	399.1814	6007827.0
2021-04-01 12:00:00	SPY	ETF	399.175	399.86	399.14	399.725	4122707.0
2021-04-01 13:00:00	SPY	ETF	399.72	399.86	399.329	399.65	4518810.0
2021-04-01 14:00:00	SPY	ETF	399.65	400.0	399.6	399.935	3707998.0
2021-04-01 15:00:00	SPY	ETF	399.9301	400.67	399.42	400.54	13366135.0
2021-04-01 16:00:00	SPY	ETF	400.535	401.08	400.53	401.0	3264236.0
2021-04-01 17:00:00	SPY	ETF	401.0	401.19	400.84	400.95	278775.0
2021-04-01 18:00:00	SPY	ETF	400.97	401.08	400.61	401.05	91551.0
2021-04-01 19:00:00	SPY	ETF	401.06	401.24	401.03	401.16	50611.0
2021-04-01 04:00:00	QQQ	ETF	321.9	322.57	321.59	322.13	131653.0
2021-04-01 05:00:00	QQQ	ETF	322.1	322.47	321.89	322.14	35531.0
2021-04-01 06:00:00	QQQ	ETF	322.11	322.12	321.79	321.9	49235.0
2021-04-01 07:00:00	QQQ	ETF	321.9	322.5	321.86	322.24	197054.0
2021-04-01 08:00:00	QQQ	ETF	322.24	322.9	319.13	322.7	261878.0
2021-04-01 09:00:00	QQQ	ETF	322.79	324.26	322.65	324.0	8892776.0
2021-04-01 10:00:00	QQQ	ETF	324.03	324.71	323.27	324.29	7316781.0
2021-04-01 11:00:00	QQQ	ETF	324.28	324.56	323.32	323.6	4724665.0
2021-04-01 12:00:00	QQQ	ETF	323.59	324.24	323.46	324.1	2809055.0
2021-04-01 13:00:00	QQQ	ETF	324.1	324.26	323.22	323.73	3253977.0
2021-04-01 14:00:00	QQQ	ETF	323.75	324.4	323.59	324.225	2829331.0
2021-04-01 15:00:00	QQQ	ETF	324.225	324.68	323.62	324.55	7020580.0
2021-04-01 16:00:00	QQQ	ETF	324.55	324.93	324.53	324.84	907574.0
2021-04-01 17:00:00	QQQ	ETF	324.95	325.0	324.57	324.86	98214.0
2021-04-01 18:00:00	QQQ	ETF	324.86	325.01	324.83	324.92	46901.0
2021-04-01 19:00:00	QQQ	ETF	324.9	325.39	324.9	325.3	61955.0
2021-04-01 04:00:00	IWM	ETF	221.64	222.18	221.64	222.18	26373.0
2021-04-01 05:00:00	IWM	ETF	222.16	222.23	221.8	221.98	32816.0
2021-04-01 06:00:00	IWM	ETF	221.98	221.98	221.6	221.7	22221.0
2021-04-01 07:00:00	IWM	ETF	221.67	222.7	221.65	222.46	167464.0
2021-04-01 08:00:00	IWM	ETF	221.7196	222.65	220.28	222.09	88010.0
2021-04-01 09:00:00	IWM	ETF	222.06	223.25	220.94	222.52	5035122.0
2021-04-01 10:00:00	IWM	ETF	222.535	223.58	222.46	222.81	2812475.0
2021-04-01 11:00:00	IWM	ETF	222.81	223.02	222.02	222.485	2759531.0
2021-04-01 12:00:00	IWM	ETF	222.465	223.26	222.445	222.82	1682484.0
2021-04-01 13:00:00	IWM	ETF	222.82	223.52	222.73	223.18	1368699.0
2021-04-01 14:00:00	IWM	ETF	223.19	223.6489	223.05	223.21	1715169.0
2021-04-01 15:00:00	IWM	ETF	223.22	223.86	222.68	223.82	4230369.0
2021-04-01 16:00:00	IWM	ETF	223.74	224.32	223.0189	224.1	1793720.0
2021-04-01 17:00:00	IWM	ETF	224.21	224.66	223.74	224.31	154541.0
2021-04-01 18:00:00	IWM	ETF	224.31	224.42	223.74	224.42	38956.0
2021-04-01 19:00:00	IWM	ETF	224.46	224.59	224.33	224.46	17281.0
2021-04-01 04:00:00	DIA	ETF	330.31	330.55	330.29	330.55	3056.0
2021-04-01 05:00:00	DIA	ETF	330.38	330.38	330.38	330.38	280.0

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

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