PREVIEW / etf_1hour / 2023-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-03-14.parquet
  size:    474 KB
  rows:    17,357

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-03-14 04:00:00	SPY	ETF	386.93	387.64	386.29	387.6	33867.0
2023-03-14 05:00:00	SPY	ETF	387.51	387.53	386.14	386.81	49432.0
2023-03-14 06:00:00	SPY	ETF	386.8	387.33	386.4	387.09	102973.0
2023-03-14 07:00:00	SPY	ETF	387.0	388.43	386.65	387.96	470409.0
2023-03-14 08:00:00	SPY	ETF	387.8	390.12	384.7	389.59	3168500.0
2023-03-14 09:00:00	SPY	ETF	389.57	391.92	389.36	391.13	16090613.0
2023-03-14 10:00:00	SPY	ETF	391.14	392.995	390.56	391.99	14416000.0
2023-03-14 11:00:00	SPY	ETF	392.0	393.45	391.9	392.53	9040895.0
2023-03-14 12:00:00	SPY	ETF	392.52	392.82	391.09	391.43	8740350.0
2023-03-14 13:00:00	SPY	ETF	391.44	391.72	388.55	389.1691	14115598.0
2023-03-14 14:00:00	SPY	ETF	389.17	390.0	387.7084	388.87	10556995.0
2023-03-14 15:00:00	SPY	ETF	388.87	392.18	387.05	391.69	30415346.0
2023-03-14 16:00:00	SPY	ETF	391.695	392.13	391.07	392.0	6117790.0
2023-03-14 17:00:00	SPY	ETF	391.81	392.03	391.73	391.74	173261.0
2023-03-14 18:00:00	SPY	ETF	391.76	391.82	391.25	391.33	197793.0
2023-03-14 19:00:00	SPY	ETF	391.35	391.75	391.35	391.63	114849.0
2023-03-14 04:00:00	QQQ	ETF	291.77	292.55	291.49	292.39	65888.0
2023-03-14 05:00:00	QQQ	ETF	292.37	292.37	291.46	291.51	69101.0
2023-03-14 06:00:00	QQQ	ETF	291.53	292.07	291.2	291.85	58688.0
2023-03-14 07:00:00	QQQ	ETF	292.01	293.01	291.9	292.49	271034.0
2023-03-14 08:00:00	QQQ	ETF	292.05	294.6	289.0	293.8	2761821.0
2023-03-14 09:00:00	QQQ	ETF	293.79	296.38	292.15	295.65	10817574.0
2023-03-14 10:00:00	QQQ	ETF	295.65	297.23	295.31	296.37	8380958.0
2023-03-14 11:00:00	QQQ	ETF	296.36	297.93	296.35	297.4	4571801.0
2023-03-14 12:00:00	QQQ	ETF	297.4	297.6999	296.63	297.042	4241571.0
2023-03-14 13:00:00	QQQ	ETF	297.03	297.26	294.83	295.221	6590335.0
2023-03-14 14:00:00	QQQ	ETF	295.21	295.9	294.0	295.04	5524141.0
2023-03-14 15:00:00	QQQ	ETF	295.06	297.76	293.45	297.39	12594581.0
2023-03-14 16:00:00	QQQ	ETF	297.39	297.54	295.25	297.53	1576561.0
2023-03-14 17:00:00	QQQ	ETF	297.4	297.46	297.32	297.37	191644.0
2023-03-14 18:00:00	QQQ	ETF	297.31	297.45	297.0	297.07	115929.0
2023-03-14 19:00:00	QQQ	ETF	297.07	297.51	297.07	297.2999	79248.0
2023-03-14 04:00:00	IWM	ETF	174.08	174.58	173.75	174.54	13976.0
2023-03-14 05:00:00	IWM	ETF	174.64	174.64	173.79	174.29	64841.0
2023-03-14 06:00:00	IWM	ETF	174.38	174.71	174.23	174.6	64500.0
2023-03-14 07:00:00	IWM	ETF	174.6	175.45	174.6	175.23	129805.0
2023-03-14 08:00:00	IWM	ETF	174.69	177.62	173.75	177.23	1063246.0
2023-03-14 09:00:00	IWM	ETF	177.35	179.07	177.21	178.1	7492320.0
2023-03-14 10:00:00	IWM	ETF	178.14	178.97	177.19	177.88	6123072.0
2023-03-14 11:00:00	IWM	ETF	177.89	179.26	177.8	178.4	3501776.0
2023-03-14 12:00:00	IWM	ETF	178.4	178.64	177.36	177.62	3634182.0
2023-03-14 13:00:00	IWM	ETF	177.63	177.77	175.775	176.04	5003791.0
2023-03-14 14:00:00	IWM	ETF	176.03	176.52	175.26	175.65	3530391.0
2023-03-14 15:00:00	IWM	ETF	175.65	176.8	174.61	176.59	6323209.0
2023-03-14 16:00:00	IWM	ETF	176.52	176.8	176.27	176.58	994455.0
2023-03-14 17:00:00	IWM	ETF	176.75	176.84	176.52	176.52	737518.0
2023-03-14 18:00:00	IWM	ETF	176.6	176.76	176.39	176.52	11548.0
2023-03-14 19:00:00	IWM	ETF	176.55	176.79	176.55	176.66	33211.0
2023-03-14 04:00:00	DIA	ETF	322.02	322.02	319.7	320.34	4695.0
2023-03-14 05:00:00	DIA	ETF	320.32	320.32	319.89	319.89	810.0

> showing 50 of 17,357 rows — these rows as CSV

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