PREVIEW / etf_1hour / 2022-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-10-28.parquet
  size:    459 KB
  rows:    16,594

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-10-28 04:00:00	SPY	ETF	376.33	377.5	376.0	377.23	49966.0
2022-10-28 05:00:00	SPY	ETF	377.19	377.69	376.5	377.65	91189.0
2022-10-28 06:00:00	SPY	ETF	377.65	377.97	377.22	377.68	74197.0
2022-10-28 07:00:00	SPY	ETF	377.82	378.571	377.16	378.1	278936.0
2022-10-28 08:00:00	SPY	ETF	377.82	380.78	376.0	378.67	1835103.0
2022-10-28 09:00:00	SPY	ETF	378.67	383.36	378.42	382.52	8524658.0
2022-10-28 10:00:00	SPY	ETF	382.57	385.8349	380.96	385.719	11751377.0
2022-10-28 11:00:00	SPY	ETF	385.72	386.2872	384.85	385.77	7643635.0
2022-10-28 12:00:00	SPY	ETF	385.76	387.42	385.01	387.1481	6789032.0
2022-10-28 13:00:00	SPY	ETF	387.16	388.08	387.04	387.52	5701407.0
2022-10-28 14:00:00	SPY	ETF	387.52	389.04	387.21	388.845	7098492.0
2022-10-28 15:00:00	SPY	ETF	388.86	389.52	388.21	388.97	14464397.0
2022-10-28 16:00:00	SPY	ETF	388.97	390.28	388.9	390.15	5581858.0
2022-10-28 17:00:00	SPY	ETF	390.12	390.2	389.7	389.7	128204.0
2022-10-28 18:00:00	SPY	ETF	389.71	390.07	389.63	389.9	57904.0
2022-10-28 19:00:00	SPY	ETF	389.99	390.23	389.5	390.2	34268.0
2022-10-28 04:00:00	QQQ	ETF	269.39	269.9	268.66	269.75	50474.0
2022-10-28 05:00:00	QQQ	ETF	269.72	269.85	268.93	269.85	45392.0
2022-10-28 06:00:00	QQQ	ETF	269.9	270.17	269.54	269.95	80112.0
2022-10-28 07:00:00	QQQ	ETF	269.9	270.77	269.5	270.24	299197.0
2022-10-28 08:00:00	QQQ	ETF	270.1	273.074	268.6704	270.68	1546692.0
2022-10-28 09:00:00	QQQ	ETF	270.71	275.88	270.41	274.8	8337990.0
2022-10-28 10:00:00	QQQ	ETF	274.83	278.47	273.275	278.22	10273735.0
2022-10-28 11:00:00	QQQ	ETF	278.23	279.0697	277.69	278.15	5081934.0
2022-10-28 12:00:00	QQQ	ETF	278.16	279.87	277.56	279.59	4751824.0
2022-10-28 13:00:00	QQQ	ETF	279.61	280.44	279.45	279.82	3107186.0
2022-10-28 14:00:00	QQQ	ETF	279.81	281.19	279.5	280.98	3909912.0
2022-10-28 15:00:00	QQQ	ETF	280.98	281.698	280.29	281.21	9325886.0
2022-10-28 16:00:00	QQQ	ETF	281.21	282.159	281.14	282.159	1791647.0
2022-10-28 17:00:00	QQQ	ETF	282.1	282.18	271.22	281.84	183250.0
2022-10-28 18:00:00	QQQ	ETF	281.8	282.0	281.8	281.95	16974.0
2022-10-28 19:00:00	QQQ	ETF	281.95	282.02	281.81	282.02	44268.0
2022-10-28 04:00:00	IWM	ETF	178.17	178.95	177.89	178.94	22713.0
2022-10-28 05:00:00	IWM	ETF	178.86	179.25	178.56	179.25	59147.0
2022-10-28 06:00:00	IWM	ETF	179.17	179.35	178.96	179.14	53822.0
2022-10-28 07:00:00	IWM	ETF	179.18	179.45	178.8	179.15	59744.0
2022-10-28 08:00:00	IWM	ETF	178.88	180.88	178.36	179.73	260513.0
2022-10-28 09:00:00	IWM	ETF	179.75	181.37	179.27	180.63	3341728.0
2022-10-28 10:00:00	IWM	ETF	180.64	181.11	178.7383	180.64	4159519.0
2022-10-28 11:00:00	IWM	ETF	180.66	181.4565	180.11	181.09	2628972.0
2022-10-28 12:00:00	IWM	ETF	181.09	182.7781	180.88	182.47	3542216.0
2022-10-28 13:00:00	IWM	ETF	182.51	182.8	182.27	182.29	2633376.0
2022-10-28 14:00:00	IWM	ETF	182.28	183.1272	182.01	183.11	2809402.0
2022-10-28 15:00:00	IWM	ETF	183.12	183.41	182.7401	183.16	4990720.0
2022-10-28 16:00:00	IWM	ETF	183.16	184.02	183.14	183.78	1120926.0
2022-10-28 17:00:00	IWM	ETF	183.76	183.77	183.16	183.51	82521.0
2022-10-28 18:00:00	IWM	ETF	183.47	183.57	183.37	183.44	9300.0
2022-10-28 19:00:00	IWM	ETF	183.44	183.65	183.0	183.03	16385.0
2022-10-28 04:00:00	DIA	ETF	319.02	319.76	319.02	319.76	1250.0
2022-10-28 05:00:00	DIA	ETF	319.38	319.38	319.33	319.34	1400.0

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

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