PREVIEW / etf_1hour / 2021-04-07

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-07.parquet
  size:    417 KB
  rows:    14,409

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-07 04:00:00	SPY	ETF	406.73	406.73	406.16	406.26	21387.0
2021-04-07 05:00:00	SPY	ETF	406.37	406.45	405.9	406.08	11271.0
2021-04-07 06:00:00	SPY	ETF	406.21	406.41	406.13	406.22	22807.0
2021-04-07 07:00:00	SPY	ETF	406.15	406.27	405.93	405.93	111738.0
2021-04-07 08:00:00	SPY	ETF	406.2401	406.3196	405.3	405.31	234297.0
2021-04-07 09:00:00	SPY	ETF	405.35	406.61	405.35	406.299	4722468.0
2021-04-07 10:00:00	SPY	ETF	406.29	406.96	406.05	406.68	5313699.0
2021-04-07 11:00:00	SPY	ETF	406.675	406.93	405.61	406.08	5598331.0
2021-04-07 12:00:00	SPY	ETF	406.07	406.31	405.45	406.07	6137200.0
2021-04-07 13:00:00	SPY	ETF	406.07	406.52	405.88	406.39	3289104.0
2021-04-07 14:00:00	SPY	ETF	406.39	406.91	406.33	406.4219	4887626.0
2021-04-07 15:00:00	SPY	ETF	406.43	406.77	405.76	406.58	11212460.0
2021-04-07 16:00:00	SPY	ETF	406.57	407.15	406.55	407.11	2275951.0
2021-04-07 17:00:00	SPY	ETF	407.12	407.12	407.01	407.1	77728.0
2021-04-07 18:00:00	SPY	ETF	407.07	407.17	406.59	407.05	101516.0
2021-04-07 19:00:00	SPY	ETF	406.98	407.9	406.9	407.64	117774.0
2021-04-07 04:00:00	QQQ	ETF	331.35	331.41	330.96	331.05	10740.0
2021-04-07 05:00:00	QQQ	ETF	331.03	331.13	330.5	330.87	24488.0
2021-04-07 06:00:00	QQQ	ETF	330.84	331.4	330.82	330.92	47852.0
2021-04-07 07:00:00	QQQ	ETF	330.89	331.05	330.56	330.64	92820.0
2021-04-07 08:00:00	QQQ	ETF	330.9896	331.6	329.82	329.82	278195.0
2021-04-07 09:00:00	QQQ	ETF	329.8	331.12	329.37	330.915	3638641.0
2021-04-07 10:00:00	QQQ	ETF	330.93	331.9999	330.68	331.53	3534807.0
2021-04-07 11:00:00	QQQ	ETF	331.54	332.245	330.61	331.4718	3458509.0
2021-04-07 12:00:00	QQQ	ETF	331.46	331.7399	330.551	330.8833	2391205.0
2021-04-07 13:00:00	QQQ	ETF	330.86	331.52	330.645	331.4	1905198.0
2021-04-07 14:00:00	QQQ	ETF	331.4	332.48	331.37	331.89	3736636.0
2021-04-07 15:00:00	QQQ	ETF	331.9	332.34	330.85	331.62	5077189.0
2021-04-07 16:00:00	QQQ	ETF	331.61	332.06	331.59	332.0	682328.0
2021-04-07 17:00:00	QQQ	ETF	331.94	332.07	331.62	332.03	32685.0
2021-04-07 18:00:00	QQQ	ETF	332.0	332.19	332.0	332.1	43957.0
2021-04-07 19:00:00	QQQ	ETF	332.1	332.78	331.89	332.44	81359.0
2021-04-07 04:00:00	IWM	ETF	224.12	224.35	224.12	224.28	4160.0
2021-04-07 05:00:00	IWM	ETF	224.34	224.42	223.82	224.17	17600.0
2021-04-07 06:00:00	IWM	ETF	224.1	224.35	224.07	224.34	18775.0
2021-04-07 07:00:00	IWM	ETF	224.25	224.62	224.23	224.33	34242.0
2021-04-07 08:00:00	IWM	ETF	224.45	224.48	223.31	223.45	190177.0
2021-04-07 09:00:00	IWM	ETF	223.47	224.37	222.3	222.78	2348328.0
2021-04-07 10:00:00	IWM	ETF	222.8	223.4	222.3	222.3289	2128886.0
2021-04-07 11:00:00	IWM	ETF	222.32	222.75	220.87	221.21	2993292.0
2021-04-07 12:00:00	IWM	ETF	221.21	222.17	220.58	222.1	2162766.0
2021-04-07 13:00:00	IWM	ETF	222.1	222.15	221.365	221.44	1673231.0
2021-04-07 14:00:00	IWM	ETF	221.43	222.42	221.13	221.3	2129004.0
2021-04-07 15:00:00	IWM	ETF	221.31	221.73	219.94	220.58	4537433.0
2021-04-07 16:00:00	IWM	ETF	220.69	221.37	220.3	220.69	1580966.0
2021-04-07 17:00:00	IWM	ETF	221.21	221.49	220.69	221.08	65866.0
2021-04-07 18:00:00	IWM	ETF	221.29	221.41	221.14	221.14	25094.0
2021-04-07 19:00:00	IWM	ETF	221.27	221.87	221.18	221.72	67411.0
2021-04-07 05:00:00	DIA	ETF	334.3	334.42	334.3	334.42	500.0
2021-04-07 06:00:00	DIA	ETF	334.47	334.51	334.45	334.51	1000.0

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

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