PREVIEW / etf_1hour / 2022-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-12-12.parquet
  size:    464 KB
  rows:    16,812

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-12-12 04:00:00	SPY	ETF	393.16	394.06	392.95	394.06	41336.0
2022-12-12 05:00:00	SPY	ETF	394.03	394.52	393.98	394.43	43515.0
2022-12-12 06:00:00	SPY	ETF	394.2	394.62	394.2	394.38	63630.0
2022-12-12 07:00:00	SPY	ETF	394.41	394.5	394.24	394.39	113419.0
2022-12-12 08:00:00	SPY	ETF	394.4	394.83	392.78	394.24	282549.0
2022-12-12 09:00:00	SPY	ETF	394.23	394.76	393.412	394.6327	5248071.0
2022-12-12 10:00:00	SPY	ETF	394.64	394.87	393.81	394.52	5601115.0
2022-12-12 11:00:00	SPY	ETF	394.53	395.69	394.34	395.416	4873791.0
2022-12-12 12:00:00	SPY	ETF	395.42	395.92	395.12	395.73	3565627.0
2022-12-12 13:00:00	SPY	ETF	395.73	396.25	395.08	395.8699	4082802.0
2022-12-12 14:00:00	SPY	ETF	395.87	396.88	395.385	396.735	5285361.0
2022-12-12 15:00:00	SPY	ETF	396.75	398.93	396.75	398.91	14698635.0
2022-12-12 16:00:00	SPY	ETF	398.92	398.95	398.21	398.41	10322764.0
2022-12-12 17:00:00	SPY	ETF	398.41	398.68	398.25	398.55	156155.0
2022-12-12 18:00:00	SPY	ETF	398.54	398.9	398.46	398.6795	108923.0
2022-12-12 19:00:00	SPY	ETF	398.74	398.98	398.6	398.76	56152.0
2022-12-12 04:00:00	QQQ	ETF	282.07	282.7	281.95	282.7	69778.0
2022-12-12 05:00:00	QQQ	ETF	282.8	283.13	282.57	282.98	17693.0
2022-12-12 06:00:00	QQQ	ETF	283.05	283.15	282.83	282.9	22347.0
2022-12-12 07:00:00	QQQ	ETF	282.99	283.05	282.66	282.71	80674.0
2022-12-12 08:00:00	QQQ	ETF	282.7199	283.15	281.52	282.66	307748.0
2022-12-12 09:00:00	QQQ	ETF	282.65	283.0236	281.42	282.7096	4829016.0
2022-12-12 10:00:00	QQQ	ETF	282.71	282.7799	281.16	281.84	4619780.0
2022-12-12 11:00:00	QQQ	ETF	281.86	282.89	281.7419	282.52	3431776.0
2022-12-12 12:00:00	QQQ	ETF	282.51	282.84	282.24	282.75	2358892.0
2022-12-12 13:00:00	QQQ	ETF	282.745	283.4	282.16	282.84	2951846.0
2022-12-12 14:00:00	QQQ	ETF	282.86	284.02	282.4	283.875	2417915.0
2022-12-12 15:00:00	QQQ	ETF	283.88	285.64	283.87	285.62	6185410.0
2022-12-12 16:00:00	QQQ	ETF	285.61	285.62	284.98	285.19	1234179.0
2022-12-12 17:00:00	QQQ	ETF	285.25	285.58	285.07	285.3	199172.0
2022-12-12 18:00:00	QQQ	ETF	285.3	285.67	285.22	285.5	63226.0
2022-12-12 19:00:00	QQQ	ETF	285.58	285.75	285.46	285.61	54342.0
2022-12-12 04:00:00	IWM	ETF	178.6	178.95	178.5	178.86	55402.0
2022-12-12 05:00:00	IWM	ETF	178.93	178.98	178.79	178.95	1925.0
2022-12-12 06:00:00	IWM	ETF	178.92	179.15	178.82	179.01	5626.0
2022-12-12 07:00:00	IWM	ETF	178.99	179.1	178.92	179.02	20502.0
2022-12-12 08:00:00	IWM	ETF	178.99	179.24	178.56	178.8	69734.0
2022-12-12 09:00:00	IWM	ETF	178.78	179.13	178.0	178.91	1911790.0
2022-12-12 10:00:00	IWM	ETF	178.93	179.88	178.27	179.78	1869926.0
2022-12-12 11:00:00	IWM	ETF	179.79	180.38	179.5601	180.16	1294532.0
2022-12-12 12:00:00	IWM	ETF	180.155	180.45	179.98	180.36	1183284.0
2022-12-12 13:00:00	IWM	ETF	180.36	180.585	179.86	180.33	1244866.0
2022-12-12 14:00:00	IWM	ETF	180.34	180.58	179.95	180.49	1528622.0
2022-12-12 15:00:00	IWM	ETF	180.49	181.09	180.49	180.8	3392785.0
2022-12-12 16:00:00	IWM	ETF	180.72	180.83	180.5	180.52	1771838.0
2022-12-12 17:00:00	IWM	ETF	180.61	180.72	180.53	180.65	139954.0
2022-12-12 18:00:00	IWM	ETF	180.65	180.88	180.62	180.77	43268.0
2022-12-12 19:00:00	IWM	ETF	180.93	181.0	180.73	180.85	26813.0
2022-12-12 04:00:00	DIA	ETF	335.09	335.66	335.09	335.66	1364.0
2022-12-12 05:00:00	DIA	ETF	336.16	336.16	336.16	336.16	100.0

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

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