PREVIEW / etf_1hour / 2021-03-24

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-03-24.parquet
  size:    414 KB
  rows:    14,566

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-03-24 04:00:00	SPY	ETF	389.5	391.08	389.25	390.88	35259.0
2021-03-24 05:00:00	SPY	ETF	390.88	391.24	390.78	390.97	23380.0
2021-03-24 06:00:00	SPY	ETF	391.02	391.07	390.55	390.79	266987.0
2021-03-24 07:00:00	SPY	ETF	390.82	391.46	390.66	390.75	260482.0
2021-03-24 08:00:00	SPY	ETF	390.77	391.45	390.62	390.96	336698.0
2021-03-24 09:00:00	SPY	ETF	390.94	392.0	390.61	390.71	7446659.0
2021-03-24 10:00:00	SPY	ETF	390.7	392.38	390.27	392.23	10570640.0
2021-03-24 11:00:00	SPY	ETF	392.24	392.75	391.18	391.465	8418848.0
2021-03-24 12:00:00	SPY	ETF	391.47	392.309	391.295	391.35	5770154.0
2021-03-24 13:00:00	SPY	ETF	391.36	391.36	389.92	391.29	7785584.0
2021-03-24 14:00:00	SPY	ETF	391.295	391.42	389.5	389.59	8715403.0
2021-03-24 15:00:00	SPY	ETF	389.6	390.185	387.48	387.48	20107978.0
2021-03-24 16:00:00	SPY	ETF	387.48	387.93	387.33	387.81	5072388.0
2021-03-24 17:00:00	SPY	ETF	387.8	387.87	387.52	387.82	205870.0
2021-03-24 18:00:00	SPY	ETF	387.82	388.15	387.52	388.03	199650.0
2021-03-24 19:00:00	SPY	ETF	387.96	388.29	387.8	388.11	63230.0
2021-03-24 04:00:00	QQQ	ETF	317.96	320.25	317.84	320.04	62593.0
2021-03-24 05:00:00	QQQ	ETF	320.02	320.4	319.61	319.88	72534.0
2021-03-24 06:00:00	QQQ	ETF	319.85	319.96	319.1	319.38	73465.0
2021-03-24 07:00:00	QQQ	ETF	319.4	319.71	318.99	319.17	142219.0
2021-03-24 08:00:00	QQQ	ETF	319.52	319.68	317.53	318.96	319681.0
2021-03-24 09:00:00	QQQ	ETF	318.95	319.01	315.6	315.86	6289522.0
2021-03-24 10:00:00	QQQ	ETF	315.84	317.22	314.76	317.0	8467875.0
2021-03-24 11:00:00	QQQ	ETF	317.0	318.09	315.68	316.04	6811638.0
2021-03-24 12:00:00	QQQ	ETF	316.03	316.59	315.27	315.32	4026248.0
2021-03-24 13:00:00	QQQ	ETF	315.32	315.6499	313.87	315.615	6287785.0
2021-03-24 14:00:00	QQQ	ETF	315.61	315.7099	313.59	313.69	6482947.0
2021-03-24 15:00:00	QQQ	ETF	313.72	314.21	311.72	311.76	11436367.0
2021-03-24 16:00:00	QQQ	ETF	311.78	312.21	311.65	311.89	970210.0
2021-03-24 17:00:00	QQQ	ETF	311.87	312.08	311.85	312.06	232515.0
2021-03-24 18:00:00	QQQ	ETF	312.0	312.36	311.59	312.1	173401.0
2021-03-24 19:00:00	QQQ	ETF	312.0799	312.31	311.87	312.18	73102.0
2021-03-24 04:00:00	IWM	ETF	217.5	218.86	217.17	218.86	15264.0
2021-03-24 05:00:00	IWM	ETF	218.87	219.48	218.39	218.46	26490.0
2021-03-24 06:00:00	IWM	ETF	218.49	219.0	218.27	218.6	62742.0
2021-03-24 07:00:00	IWM	ETF	218.58	219.38	218.56	218.75	115068.0
2021-03-24 08:00:00	IWM	ETF	218.73	220.06	217.33	219.43	278598.0
2021-03-24 09:00:00	IWM	ETF	219.34	220.73	218.61	218.78	4845698.0
2021-03-24 10:00:00	IWM	ETF	218.76	221.33	218.18	220.79	4216096.0
2021-03-24 11:00:00	IWM	ETF	220.81	221.1099	218.27	218.71	2553353.0
2021-03-24 12:00:00	IWM	ETF	218.71	219.59	217.86	218.19	2485566.0
2021-03-24 13:00:00	IWM	ETF	218.2	218.22	216.62	217.74	3389785.0
2021-03-24 14:00:00	IWM	ETF	217.74	217.79	214.65	214.765	4437285.0
2021-03-24 15:00:00	IWM	ETF	214.77	215.37	212.05	212.06	11664214.0
2021-03-24 16:00:00	IWM	ETF	212.04	213.1363	211.95	212.69	2385069.0
2021-03-24 17:00:00	IWM	ETF	212.57	213.0	212.04	212.85	195214.0
2021-03-24 18:00:00	IWM	ETF	212.93	213.1	212.04	212.83	43324.0
2021-03-24 19:00:00	IWM	ETF	212.8	213.16	212.72	213.05	33195.0
2021-03-24 04:00:00	DIA	ETF	324.09	324.85	323.99	324.85	2935.0
2021-03-24 05:00:00	DIA	ETF	325.0	325.28	324.98	325.04	3500.0

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

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