PREVIEW / etf_1hour / 2021-05-13

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-13.parquet
  size:    425 KB
  rows:    14,873

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-05-13 04:00:00	SPY	ETF	403.96	404.46	402.7	403.67	128421.0
2021-05-13 05:00:00	SPY	ETF	403.79	404.82	403.51	404.32	68870.0
2021-05-13 06:00:00	SPY	ETF	404.29	404.52	403.4	404.43	129780.0
2021-05-13 07:00:00	SPY	ETF	404.35	406.25	404.17	405.66	721104.0
2021-05-13 08:00:00	SPY	ETF	405.65	407.17	403.6104	406.6	1219608.0
2021-05-13 09:00:00	SPY	ETF	406.6	410.07	406.56	410.04	10822429.0
2021-05-13 10:00:00	SPY	ETF	410.05	412.02	410.05	411.81	14165737.0
2021-05-13 11:00:00	SPY	ETF	411.82	411.93	409.2101	409.665	11203373.0
2021-05-13 12:00:00	SPY	ETF	409.67	411.13	409.47	409.86	7592839.0
2021-05-13 13:00:00	SPY	ETF	409.85	410.44	407.84	408.8	11604449.0
2021-05-13 14:00:00	SPY	ETF	408.82	411.7	408.7599	411.05	10991082.0
2021-05-13 15:00:00	SPY	ETF	411.05	412.35	410.21	410.25	20891550.0
2021-05-13 16:00:00	SPY	ETF	410.26	410.78	409.86	410.73	3712382.0
2021-05-13 17:00:00	SPY	ETF	410.73	410.87	410.3955	410.7	313440.0
2021-05-13 18:00:00	SPY	ETF	410.78	410.9	410.28	410.67	104494.0
2021-05-13 19:00:00	SPY	ETF	410.63	411.17	410.22	411.0	98146.0
2021-05-13 04:00:00	QQQ	ETF	317.0	317.0	314.96	315.79	117902.0
2021-05-13 05:00:00	QQQ	ETF	315.8	316.6	315.5	315.93	89336.0
2021-05-13 06:00:00	QQQ	ETF	316.1	316.42	315.44	316.14	114931.0
2021-05-13 07:00:00	QQQ	ETF	316.16	319.01	315.9	318.29	959223.0
2021-05-13 08:00:00	QQQ	ETF	315.9396	320.0	315.5496	319.13	1204802.0
2021-05-13 09:00:00	QQQ	ETF	319.17	321.08	319.1	320.85	7962862.0
2021-05-13 10:00:00	QQQ	ETF	320.85	322.4	320.69	321.83	7906042.0
2021-05-13 11:00:00	QQQ	ETF	321.83	321.95	318.38	318.91	8587961.0
2021-05-13 12:00:00	QQQ	ETF	318.9	320.53	318.6	318.7201	4615131.0
2021-05-13 13:00:00	QQQ	ETF	318.72	319.36	316.9	317.94	7107369.0
2021-05-13 14:00:00	QQQ	ETF	317.94	320.75	317.89	319.98	6936989.0
2021-05-13 15:00:00	QQQ	ETF	319.98	321.08	319.24	319.35	8010690.0
2021-05-13 16:00:00	QQQ	ETF	319.34	319.4337	318.5901	319.12	1489338.0
2021-05-13 17:00:00	QQQ	ETF	319.12	319.34	318.85	319.28	111085.0
2021-05-13 18:00:00	QQQ	ETF	319.3	319.57	319.05	319.2	116948.0
2021-05-13 19:00:00	QQQ	ETF	319.3	319.82	318.71	319.67	123338.0
2021-05-13 04:00:00	IWM	ETF	210.9	211.02	210.19	210.76	13112.0
2021-05-13 05:00:00	IWM	ETF	211.1	211.58	210.86	211.2	29750.0
2021-05-13 06:00:00	IWM	ETF	211.11	211.42	210.56	211.33	26201.0
2021-05-13 07:00:00	IWM	ETF	211.24	212.83	211.0	212.66	174041.0
2021-05-13 08:00:00	IWM	ETF	211.5401	213.72	210.96	213.19	433092.0
2021-05-13 09:00:00	IWM	ETF	213.3	216.725	212.77	216.6284	5835998.0
2021-05-13 10:00:00	IWM	ETF	216.68	217.44	215.27	215.66	5038577.0
2021-05-13 11:00:00	IWM	ETF	215.71	216.4	213.29	213.44	3738535.0
2021-05-13 12:00:00	IWM	ETF	213.44	214.63	212.93	213.35	2633342.0
2021-05-13 13:00:00	IWM	ETF	213.35	214.15	211.8	213.01	3448542.0
2021-05-13 14:00:00	IWM	ETF	213.03	215.8	213.0	214.81	3174911.0
2021-05-13 15:00:00	IWM	ETF	214.84	216.74	214.84	215.75	4755741.0
2021-05-13 16:00:00	IWM	ETF	215.75	216.06	215.41	215.95	940323.0
2021-05-13 17:00:00	IWM	ETF	215.75	216.1	215.75	216.1	49102.0
2021-05-13 18:00:00	IWM	ETF	215.99	216.29	215.89	216.09	14253.0
2021-05-13 19:00:00	IWM	ETF	215.88	216.23	215.74	216.22	52280.0
2021-05-13 04:00:00	DIA	ETF	335.0	335.0	333.21	333.84	14406.0
2021-05-13 05:00:00	DIA	ETF	334.18	334.7	333.78	334.31	7585.0

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

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