PREVIEW / etf_1hour / 2023-09-27

all etf 1-hour files

  file:    by_date/etf_1hour/2023/2023-09-27.parquet
  size:    484 KB
  rows:    17,869

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-09-27 04:00:00	SPY	ETF	428.0	428.1	427.41	427.76	28220.0
2023-09-27 05:00:00	SPY	ETF	427.89	427.94	427.23	427.4	40228.0
2023-09-27 06:00:00	SPY	ETF	427.38	427.54	427.16	427.52	44259.0
2023-09-27 07:00:00	SPY	ETF	427.46	427.84	427.12	427.69	262779.0
2023-09-27 08:00:00	SPY	ETF	427.41	428.0696	426.87	427.73	648736.0
2023-09-27 09:00:00	SPY	ETF	427.68	427.94	426.64	426.88	5584791.0
2023-09-27 10:00:00	SPY	ETF	426.905	427.119	425.01	425.16	11079488.0
2023-09-27 11:00:00	SPY	ETF	425.17	426.12	424.59	424.8809	8335369.0
2023-09-27 12:00:00	SPY	ETF	424.88	424.89	423.76	424.07	8858069.0
2023-09-27 13:00:00	SPY	ETF	424.0699	424.68	422.29	423.31	9742649.0
2023-09-27 14:00:00	SPY	ETF	423.309	426.33	422.605	425.88	13234615.0
2023-09-27 15:00:00	SPY	ETF	425.885	427.539	424.855	426.02	20297856.0
2023-09-27 16:00:00	SPY	ETF	426.02	427.0	425.11	426.67	3632157.0
2023-09-27 17:00:00	SPY	ETF	426.8	426.89	426.62	426.87	92053.0
2023-09-27 18:00:00	SPY	ETF	426.85	426.89	426.06	426.36	129923.0
2023-09-27 19:00:00	SPY	ETF	426.36	426.73	426.24	426.66	54612.0
2023-09-27 04:00:00	QQQ	ETF	356.29	356.35	355.37	356.04	85410.0
2023-09-27 05:00:00	QQQ	ETF	355.98	356.01	355.41	355.59	37873.0
2023-09-27 06:00:00	QQQ	ETF	355.54	355.72	355.2	355.58	33045.0
2023-09-27 07:00:00	QQQ	ETF	355.65	355.94	355.26	355.75	84769.0
2023-09-27 08:00:00	QQQ	ETF	355.16	356.3296	354.475	355.8	308532.0
2023-09-27 09:00:00	QQQ	ETF	355.71	356.63	355.28	355.61	3642758.0
2023-09-27 10:00:00	QQQ	ETF	355.64	355.859	353.67	353.82	7440507.0
2023-09-27 11:00:00	QQQ	ETF	353.84	355.1297	353.43	353.69	4356737.0
2023-09-27 12:00:00	QQQ	ETF	353.69	353.7	352.73	353.044	4136604.0
2023-09-27 13:00:00	QQQ	ETF	353.05	353.71	351.36	352.17	4945141.0
2023-09-27 14:00:00	QQQ	ETF	352.15	355.38	351.55	355.02	7500264.0
2023-09-27 15:00:00	QQQ	ETF	355.02	356.98	354.12	355.13	10880543.0
2023-09-27 16:00:00	QQQ	ETF	355.12	355.94	354.98	355.68	1617097.0
2023-09-27 17:00:00	QQQ	ETF	355.73	355.84	355.65	355.8	32773.0
2023-09-27 18:00:00	QQQ	ETF	355.8	355.82	355.15	355.42	105219.0
2023-09-27 19:00:00	QQQ	ETF	355.4496	355.91	355.36	355.9	61556.0
2023-09-27 04:00:00	IWM	ETF	175.4	175.57	175.34	175.37	25701.0
2023-09-27 05:00:00	IWM	ETF	175.39	175.46	175.16	175.2	23012.0
2023-09-27 06:00:00	IWM	ETF	175.15	175.25	175.04	175.2	32148.0
2023-09-27 07:00:00	IWM	ETF	175.19	175.37	175.04	175.28	52219.0
2023-09-27 08:00:00	IWM	ETF	175.3497	175.47	175.02	175.47	115364.0
2023-09-27 09:00:00	IWM	ETF	175.45	176.57	175.36	176.53	4210654.0
2023-09-27 10:00:00	IWM	ETF	176.54	176.77	175.82	175.91	5119623.0
2023-09-27 11:00:00	IWM	ETF	175.92	176.52	175.74	175.88	2308142.0
2023-09-27 12:00:00	IWM	ETF	175.86	175.86	174.93	175.2901	3440635.0
2023-09-27 13:00:00	IWM	ETF	175.29	175.64	174.4619	175.22	3335137.0
2023-09-27 14:00:00	IWM	ETF	175.2169	176.5	174.99	176.28	3051438.0
2023-09-27 15:00:00	IWM	ETF	176.275	176.93	175.81	176.06	6098887.0
2023-09-27 16:00:00	IWM	ETF	175.99	176.49	175.99	176.43	1137516.0
2023-09-27 17:00:00	IWM	ETF	176.49	176.67	176.37	176.55	13092.0
2023-09-27 18:00:00	IWM	ETF	176.42	176.42	176.1	176.3	28657.0
2023-09-27 19:00:00	IWM	ETF	176.3	176.42	176.25	176.41	37716.0
2023-09-27 04:00:00	DIA	ETF	337.45	337.45	337.23	337.29	3387.0
2023-09-27 05:00:00	DIA	ETF	337.28	337.28	336.95	336.95	2100.0

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

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