PREVIEW / etf_1hour / 2023-02-13

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-02-13.parquet
  size:    470 KB
  rows:    16,905

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
2023-02-13 04:00:00	SPY	ETF	408.02	408.44	407.81	408.11	28663.0
2023-02-13 05:00:00	SPY	ETF	408.11	408.29	407.74	408.22	12621.0
2023-02-13 06:00:00	SPY	ETF	408.28	408.65	408.21	408.49	31427.0
2023-02-13 07:00:00	SPY	ETF	408.46	409.54	408.46	409.2	242024.0
2023-02-13 08:00:00	SPY	ETF	408.51	409.55	406.36	408.32	440873.0
2023-02-13 09:00:00	SPY	ETF	408.3	410.35	408.24	410.3	5337885.0
2023-02-13 10:00:00	SPY	ETF	410.32	411.86	409.94	411.44	7510437.0
2023-02-13 11:00:00	SPY	ETF	411.445	412.38	411.1001	411.89	5403497.0
2023-02-13 12:00:00	SPY	ETF	411.89	412.55	411.79	412.1701	3072341.0
2023-02-13 13:00:00	SPY	ETF	412.16	412.78	411.63	412.75	3981848.0
2023-02-13 14:00:00	SPY	ETF	412.76	412.97	411.14	411.73	6032594.0
2023-02-13 15:00:00	SPY	ETF	411.74	412.84	411.08	412.82	13944420.0
2023-02-13 16:00:00	SPY	ETF	412.83	413.09	412.7527	412.91	3645323.0
2023-02-13 17:00:00	SPY	ETF	412.92	412.99	412.83	412.86	83356.0
2023-02-13 18:00:00	SPY	ETF	412.9	412.93	412.76	412.86	67504.0
2023-02-13 19:00:00	SPY	ETF	412.81	412.81	412.37	412.64	105385.0
2023-02-13 04:00:00	QQQ	ETF	299.9	300.62	299.9	300.26	79475.0
2023-02-13 05:00:00	QQQ	ETF	300.3	300.98	300.14	300.98	22110.0
2023-02-13 06:00:00	QQQ	ETF	300.89	301.18	300.79	300.98	58906.0
2023-02-13 07:00:00	QQQ	ETF	300.91	301.89	300.87	301.48	155814.0
2023-02-13 08:00:00	QQQ	ETF	301.08	301.85	298.33	300.73	360675.0
2023-02-13 09:00:00	QQQ	ETF	300.72	302.67	299.93	302.57	4577722.0
2023-02-13 10:00:00	QQQ	ETF	302.58	303.7	301.48	303.28	5139702.0
2023-02-13 11:00:00	QQQ	ETF	303.335	304.7	303.335	304.2189	3863662.0
2023-02-13 12:00:00	QQQ	ETF	304.22	304.79	304.15	304.37	2353338.0
2023-02-13 13:00:00	QQQ	ETF	304.37	305.1	303.78	304.93	3095070.0
2023-02-13 14:00:00	QQQ	ETF	304.95	305.09	303.12	303.728	3552645.0
2023-02-13 15:00:00	QQQ	ETF	303.74	304.63	303.0612	304.585	5962178.0
2023-02-13 16:00:00	QQQ	ETF	304.59	304.7	304.3571	304.6	1626779.0
2023-02-13 17:00:00	QQQ	ETF	304.61	304.78	304.47	304.55	70541.0
2023-02-13 18:00:00	QQQ	ETF	304.55	304.65	304.38	304.49	60270.0
2023-02-13 19:00:00	QQQ	ETF	304.47	304.47	304.1	304.33	86588.0
2023-02-13 04:00:00	IWM	ETF	190.3	190.45	190.17	190.26	17330.0
2023-02-13 05:00:00	IWM	ETF	190.22	190.32	190.1	190.21	3439.0
2023-02-13 06:00:00	IWM	ETF	190.32	190.46	190.27	190.36	6578.0
2023-02-13 07:00:00	IWM	ETF	190.4	190.86	190.27	190.7	41481.0
2023-02-13 08:00:00	IWM	ETF	190.34	190.86	190.34	190.37	86892.0
2023-02-13 09:00:00	IWM	ETF	190.37	191.14	189.31	191.02	1435585.0
2023-02-13 10:00:00	IWM	ETF	191.06	191.83	190.65	191.49	1308581.0
2023-02-13 11:00:00	IWM	ETF	191.5	191.97	191.27	191.915	1123494.0
2023-02-13 12:00:00	IWM	ETF	191.91	192.4	191.86	192.24	1097184.0
2023-02-13 13:00:00	IWM	ETF	192.24	192.76	191.98	192.735	885727.0
2023-02-13 14:00:00	IWM	ETF	192.73	192.855	191.86	192.14	734191.0
2023-02-13 15:00:00	IWM	ETF	192.13	192.64	191.8	192.61	1930041.0
2023-02-13 16:00:00	IWM	ETF	192.6	192.81	192.55	192.6	1634154.0
2023-02-13 17:00:00	IWM	ETF	192.55	192.7	192.55	192.58	2969.0
2023-02-13 18:00:00	IWM	ETF	192.58	192.68	192.51	192.6	12057.0
2023-02-13 19:00:00	IWM	ETF	192.51	192.7	192.37	192.48	25296.0
2023-02-13 04:00:00	DIA	ETF	338.5	338.5	338.49	338.5	1100.0
2023-02-13 05:00:00	DIA	ETF	338.6	338.6	338.36	338.43	3400.0

> showing 50 of 16,905 rows — these rows as CSV

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