PREVIEW / etf_1hour / 2022-11-28

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-11-28.parquet
  size:    468 KB
  rows:    16,897

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-11-28 04:00:00	SPY	ETF	400.91	400.91	398.38	398.55	52134.0
2022-11-28 05:00:00	SPY	ETF	398.51	399.25	398.31	398.95	38164.0
2022-11-28 06:00:00	SPY	ETF	398.95	399.52	398.72	399.32	92022.0
2022-11-28 07:00:00	SPY	ETF	399.33	399.65	399.2	399.4	228924.0
2022-11-28 08:00:00	SPY	ETF	399.42	400.6	398.4596	399.2801	314493.0
2022-11-28 09:00:00	SPY	ETF	399.3	400.81	398.69	399.8671	4695708.0
2022-11-28 10:00:00	SPY	ETF	399.85	400.24	398.41	398.51	6381565.0
2022-11-28 11:00:00	SPY	ETF	398.51	399.08	398.19	398.872	4375576.0
2022-11-28 12:00:00	SPY	ETF	398.88	399.44	397.58	397.65	6239091.0
2022-11-28 13:00:00	SPY	ETF	397.65	398.0277	396.4432	396.57	4174109.0
2022-11-28 14:00:00	SPY	ETF	396.57	396.76	395.81	395.99	5254339.0
2022-11-28 15:00:00	SPY	ETF	396.025	396.27	395.11	395.92	12319942.0
2022-11-28 16:00:00	SPY	ETF	395.925	396.37	395.91	396.23	6494511.0
2022-11-28 17:00:00	SPY	ETF	396.22	396.28	396.05	396.2	35055.0
2022-11-28 18:00:00	SPY	ETF	396.25	396.29	396.04	396.19	74441.0
2022-11-28 19:00:00	SPY	ETF	396.13	396.54	396.02	396.44	85519.0
2022-11-28 04:00:00	QQQ	ETF	284.87	285.02	283.6	283.66	78866.0
2022-11-28 05:00:00	QQQ	ETF	283.66	284.33	283.48	284.15	41095.0
2022-11-28 06:00:00	QQQ	ETF	284.16	284.71	284.04	284.66	58442.0
2022-11-28 07:00:00	QQQ	ETF	284.72	285.04	284.61	284.85	123134.0
2022-11-28 08:00:00	QQQ	ETF	284.68	287.135	284.0404	285.13	312693.0
2022-11-28 09:00:00	QQQ	ETF	285.16	286.96	284.6	286.2095	3921079.0
2022-11-28 10:00:00	QQQ	ETF	286.205	286.475	284.29	284.45	5268330.0
2022-11-28 11:00:00	QQQ	ETF	284.4334	285.2	284.1	285.07	2764672.0
2022-11-28 12:00:00	QQQ	ETF	285.075	285.62	283.9	284.02	3630982.0
2022-11-28 13:00:00	QQQ	ETF	284.02	284.475	283.03	283.1	2512438.0
2022-11-28 14:00:00	QQQ	ETF	283.085	283.235	282.2522	282.71	3805363.0
2022-11-28 15:00:00	QQQ	ETF	282.73	282.9	281.76	282.63	6294114.0
2022-11-28 16:00:00	QQQ	ETF	282.64	283.05	282.6253	282.97	2364924.0
2022-11-28 17:00:00	QQQ	ETF	282.92	283.0	282.71	282.88	175079.0
2022-11-28 18:00:00	QQQ	ETF	282.88	282.97	282.74	282.85	55188.0
2022-11-28 19:00:00	QQQ	ETF	282.81	283.16	282.69	283.07	122070.0
2022-11-28 04:00:00	IWM	ETF	184.53	184.66	183.78	183.78	20030.0
2022-11-28 05:00:00	IWM	ETF	183.81	184.29	183.76	184.05	6564.0
2022-11-28 06:00:00	IWM	ETF	184.07	184.34	183.9	184.19	73911.0
2022-11-28 07:00:00	IWM	ETF	184.24	184.37	184.15	184.32	27029.0
2022-11-28 08:00:00	IWM	ETF	184.21	184.55	184.1	184.44	56772.0
2022-11-28 09:00:00	IWM	ETF	184.45	184.92	183.9245	184.13	1754994.0
2022-11-28 10:00:00	IWM	ETF	184.1	184.54	183.34	183.34	2301993.0
2022-11-28 11:00:00	IWM	ETF	183.35	183.85	183.29	183.7	1150954.0
2022-11-28 12:00:00	IWM	ETF	183.695	183.99	183.06	183.14	1342236.0
2022-11-28 13:00:00	IWM	ETF	183.14	183.295	182.44	182.53	1141919.0
2022-11-28 14:00:00	IWM	ETF	182.53	182.615	181.965	182.05	1598756.0
2022-11-28 15:00:00	IWM	ETF	182.06	182.09	181.29	181.81	3157425.0
2022-11-28 16:00:00	IWM	ETF	181.84	182.13	181.79	182.06	458580.0
2022-11-28 17:00:00	IWM	ETF	182.27	182.27	181.84	182.0	309744.0
2022-11-28 18:00:00	IWM	ETF	182.05	182.13	182.0	182.08	22103.0
2022-11-28 19:00:00	IWM	ETF	182.01	182.26	181.92	182.17	15420.0
2022-11-28 04:00:00	DIA	ETF	343.0	343.0	341.3	341.3	4470.0
2022-11-28 05:00:00	DIA	ETF	341.13	341.57	341.13	341.57	1928.0

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

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