PREVIEW / etf_1hour / 2022-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-08-09.parquet
  size:    431 KB
  rows:    15,557

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
2022-08-09 04:00:00	SPY	ETF	413.51	413.8	413.14	413.65	6352.0
2022-08-09 05:00:00	SPY	ETF	413.65	413.91	413.42	413.52	11597.0
2022-08-09 06:00:00	SPY	ETF	413.28	413.28	412.0	412.23	58748.0
2022-08-09 07:00:00	SPY	ETF	412.36	412.66	411.41	411.59	147098.0
2022-08-09 08:00:00	SPY	ETF	412.0499	413.85	411.28	412.07	304921.0
2022-08-09 09:00:00	SPY	ETF	412.08	412.99	410.91	411.1353	4345222.0
2022-08-09 10:00:00	SPY	ETF	411.13	412.15	410.73	411.33	5256387.0
2022-08-09 11:00:00	SPY	ETF	411.34	412.33	410.36	411.32	4670678.0
2022-08-09 12:00:00	SPY	ETF	411.32	411.58	410.45	410.8901	3228523.0
2022-08-09 13:00:00	SPY	ETF	410.9022	411.4999	410.3032	411.285	3831105.0
2022-08-09 14:00:00	SPY	ETF	411.286	411.55	410.22	411.04	4097503.0
2022-08-09 15:00:00	SPY	ETF	411.03	411.74	410.76	411.34	8266506.0
2022-08-09 16:00:00	SPY	ETF	411.34	411.82	411.33	411.82	2044363.0
2022-08-09 17:00:00	SPY	ETF	411.84	412.0	411.68	411.7	92363.0
2022-08-09 18:00:00	SPY	ETF	411.73	411.78	411.51	411.6	48014.0
2022-08-09 19:00:00	SPY	ETF	411.56	411.8	411.53	411.79	63478.0
2022-08-09 04:00:00	QQQ	ETF	320.98	321.11	320.42	321.07	42882.0
2022-08-09 05:00:00	QQQ	ETF	321.11	321.11	320.27	320.37	55326.0
2022-08-09 06:00:00	QQQ	ETF	320.44	320.44	318.78	319.14	190902.0
2022-08-09 07:00:00	QQQ	ETF	319.1	319.55	318.34	318.5	568006.0
2022-08-09 08:00:00	QQQ	ETF	319.45	321.85	318.19	318.8	392259.0
2022-08-09 09:00:00	QQQ	ETF	318.76	319.03	316.1606	316.37	5538660.0
2022-08-09 10:00:00	QQQ	ETF	316.33	317.81	315.65	316.95	4674531.0
2022-08-09 11:00:00	QQQ	ETF	317.0	317.94	315.91	316.58	3736183.0
2022-08-09 12:00:00	QQQ	ETF	316.58	316.77	315.42	315.9199	2894657.0
2022-08-09 13:00:00	QQQ	ETF	315.91	317.08	315.64	316.89	2412511.0
2022-08-09 14:00:00	QQQ	ETF	316.885	317.5	316.03	317.025	2871125.0
2022-08-09 15:00:00	QQQ	ETF	317.02	317.72	316.7909	317.04	5451805.0
2022-08-09 16:00:00	QQQ	ETF	317.05	317.63	316.7643	317.63	926244.0
2022-08-09 17:00:00	QQQ	ETF	317.64	317.67	317.3	317.33	88096.0
2022-08-09 18:00:00	QQQ	ETF	317.34	317.6	317.27	317.45	49246.0
2022-08-09 19:00:00	QQQ	ETF	317.33	317.62	317.24	317.54	61207.0
2022-08-09 04:00:00	IWM	ETF	193.23	193.38	192.98	193.3	12100.0
2022-08-09 05:00:00	IWM	ETF	193.24	193.39	193.02	193.02	7802.0
2022-08-09 06:00:00	IWM	ETF	193.08	193.08	192.49	192.6	22723.0
2022-08-09 07:00:00	IWM	ETF	192.57	192.73	192.07	192.18	69080.0
2022-08-09 08:00:00	IWM	ETF	192.6	192.65	192.03	192.34	37960.0
2022-08-09 09:00:00	IWM	ETF	192.3	192.4	190.64	191.03	2368171.0
2022-08-09 10:00:00	IWM	ETF	191.01	191.04	190.165	190.44	1938900.0
2022-08-09 11:00:00	IWM	ETF	190.44	190.84	189.74	189.82	1415212.0
2022-08-09 12:00:00	IWM	ETF	189.8	190.04	189.45	189.66	986410.0
2022-08-09 13:00:00	IWM	ETF	189.6601	189.85	189.16	189.68	999059.0
2022-08-09 14:00:00	IWM	ETF	189.69	189.9807	189.26	189.75	1276903.0
2022-08-09 15:00:00	IWM	ETF	189.73	190.26	189.44	190.2	2601260.0
2022-08-09 16:00:00	IWM	ETF	190.19	190.39	190.1	190.34	1789469.0
2022-08-09 17:00:00	IWM	ETF	190.38	190.52	190.19	190.2	62558.0
2022-08-09 18:00:00	IWM	ETF	190.3	190.3	190.16	190.19	28695.0
2022-08-09 19:00:00	IWM	ETF	190.19	190.31	190.07	190.07	23058.0
2022-08-09 06:00:00	DIA	ETF	328.48	328.51	328.48	328.51	9880.0
2022-08-09 07:00:00	DIA	ETF	328.53	328.6	327.88	327.95	11186.0

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

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