PREVIEW / etf_1hour / 2022-03-14

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-03-14.parquet
  size:    461 KB
  rows:    16,819

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-03-14 04:00:00	SPY	ETF	422.7	423.98	421.79	422.44	85243.0
2022-03-14 05:00:00	SPY	ETF	423.0	425.05	422.24	424.59	80669.0
2022-03-14 06:00:00	SPY	ETF	424.61	424.63	423.25	424.08	58289.0
2022-03-14 07:00:00	SPY	ETF	424.04	424.05	420.68	420.8	416449.0
2022-03-14 08:00:00	SPY	ETF	423.34	424.5704	420.54	422.2699	789772.0
2022-03-14 09:00:00	SPY	ETF	422.22	422.24	419.11	421.33	9050521.0
2022-03-14 10:00:00	SPY	ETF	421.34	424.33	420.5	424.315	10820062.0
2022-03-14 11:00:00	SPY	ETF	424.33	424.55	419.91	420.46	8098336.0
2022-03-14 12:00:00	SPY	ETF	420.45	420.46	417.83	417.9	9132542.0
2022-03-14 13:00:00	SPY	ETF	417.9	418.14	416.12	416.71	9119135.0
2022-03-14 14:00:00	SPY	ETF	416.71	417.29	415.79	417.12	7613442.0
2022-03-14 15:00:00	SPY	ETF	417.13	418.2	416.01	417.06	17426974.0
2022-03-14 16:00:00	SPY	ETF	417.06	418.11	416.85	417.74	4197029.0
2022-03-14 17:00:00	SPY	ETF	417.83	417.88	417.0	417.65	148569.0
2022-03-14 18:00:00	SPY	ETF	417.65	418.48	417.38	418.2	179378.0
2022-03-14 19:00:00	SPY	ETF	418.2	418.29	417.7	417.89	108681.0
2022-03-14 04:00:00	QQQ	ETF	325.04	328.0	324.39	325.29	114332.0
2022-03-14 05:00:00	QQQ	ETF	325.3	327.73	324.97	327.04	116147.0
2022-03-14 06:00:00	QQQ	ETF	327.04	327.1	325.83	326.39	131959.0
2022-03-14 07:00:00	QQQ	ETF	326.42	326.5	322.54	322.81	505489.0
2022-03-14 08:00:00	QQQ	ETF	324.1999	327.8496	322.56	324.61	599538.0
2022-03-14 09:00:00	QQQ	ETF	324.68	325.32	322.02	323.7393	7646357.0
2022-03-14 10:00:00	QQQ	ETF	323.71	326.59	322.8	326.0	9023732.0
2022-03-14 11:00:00	QQQ	ETF	326.02	326.19	321.26	321.65	7375283.0
2022-03-14 12:00:00	QQQ	ETF	321.6	321.65	318.91	318.96	8134724.0
2022-03-14 13:00:00	QQQ	ETF	318.95	319.68	317.61	318.74	9263554.0
2022-03-14 14:00:00	QQQ	ETF	318.71	319.33	317.77	319.02	4982815.0
2022-03-14 15:00:00	QQQ	ETF	319.02	319.98	317.45	318.21	11533391.0
2022-03-14 16:00:00	QQQ	ETF	318.25	319.22	317.736	319.03	2995708.0
2022-03-14 17:00:00	QQQ	ETF	318.97	319.05	318.17	319.02	471883.0
2022-03-14 18:00:00	QQQ	ETF	319.0	319.77	318.17	319.55	213652.0
2022-03-14 19:00:00	QQQ	ETF	319.54	319.87	319.15	319.63	176819.0
2022-03-14 04:00:00	IWM	ETF	197.82	198.52	197.67	197.97	16629.0
2022-03-14 05:00:00	IWM	ETF	198.28	199.3	197.99	199.09	19184.0
2022-03-14 06:00:00	IWM	ETF	199.09	199.09	198.38	198.69	69646.0
2022-03-14 07:00:00	IWM	ETF	198.74	198.74	197.09	197.33	72040.0
2022-03-14 08:00:00	IWM	ETF	197.13	198.6204	196.99	197.52	123800.0
2022-03-14 09:00:00	IWM	ETF	197.58	197.67	194.935	195.81	3376686.0
2022-03-14 10:00:00	IWM	ETF	195.81	197.15	195.39	196.65	2707868.0
2022-03-14 11:00:00	IWM	ETF	196.67	196.74	194.1	194.43	2275131.0
2022-03-14 12:00:00	IWM	ETF	194.42	194.63	193.54	193.58	1873221.0
2022-03-14 13:00:00	IWM	ETF	193.57	193.64	192.17	192.28	2810077.0
2022-03-14 14:00:00	IWM	ETF	192.27	192.96	192.03	192.69	2335296.0
2022-03-14 15:00:00	IWM	ETF	192.7	193.2	191.88	192.92	5427748.0
2022-03-14 16:00:00	IWM	ETF	192.91	193.3	192.71	193.06	4710680.0
2022-03-14 17:00:00	IWM	ETF	193.16	193.18	192.71	193.0	45073.0
2022-03-14 18:00:00	IWM	ETF	193.1	193.57	192.94	193.32	29722.0
2022-03-14 19:00:00	IWM	ETF	193.13	193.28	192.91	192.98	27659.0
2022-03-14 04:00:00	DIA	ETF	333.25	333.25	332.46	332.46	1712.0
2022-03-14 05:00:00	DIA	ETF	332.44	333.98	332.44	333.98	2904.0

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

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