PREVIEW / etf_1hour / 2022-03-21

all etf 1-hour files

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

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-21 04:00:00	SPY	ETF	443.34	444.48	443.18	443.81	66892.0
2022-03-21 05:00:00	SPY	ETF	443.99	444.41	443.1	444.0	24236.0
2022-03-21 06:00:00	SPY	ETF	443.85	444.04	443.35	443.88	56818.0
2022-03-21 07:00:00	SPY	ETF	443.86	445.2	443.8	444.65	265232.0
2022-03-21 08:00:00	SPY	ETF	443.9001	445.07	442.43	444.38	525814.0
2022-03-21 09:00:00	SPY	ETF	444.34	446.46	443.82	443.948	9224400.0
2022-03-21 10:00:00	SPY	ETF	443.93	445.12	442.73	444.88	9227758.0
2022-03-21 11:00:00	SPY	ETF	444.89	445.78	444.35	445.4644	7023485.0
2022-03-21 12:00:00	SPY	ETF	445.48	445.9	442.16	442.39	9249997.0
2022-03-21 13:00:00	SPY	ETF	442.41	442.66	440.68	442.55	7555138.0
2022-03-21 14:00:00	SPY	ETF	442.54	444.01	441.73	441.87	7172391.0
2022-03-21 15:00:00	SPY	ETF	441.88	444.485	441.69	444.43	13018845.0
2022-03-21 16:00:00	SPY	ETF	444.44	445.2	444.21	444.98	3399334.0
2022-03-21 17:00:00	SPY	ETF	444.97	445.03	444.7	444.9	92790.0
2022-03-21 18:00:00	SPY	ETF	444.86	444.88	444.24	444.33	124139.0
2022-03-21 19:00:00	SPY	ETF	444.31	444.34	443.67	443.7	121051.0
2022-03-21 04:00:00	QQQ	ETF	350.76	355.0	349.35	349.6	165445.0
2022-03-21 05:00:00	QQQ	ETF	349.72	350.34	348.96	350.05	161529.0
2022-03-21 06:00:00	QQQ	ETF	350.01	350.18	349.6	350.03	48865.0
2022-03-21 07:00:00	QQQ	ETF	349.99	351.52	349.97	350.88	287780.0
2022-03-21 08:00:00	QQQ	ETF	350.86	351.51	348.95	350.08	626822.0
2022-03-21 09:00:00	QQQ	ETF	350.06	352.48	348.21	348.45	7351642.0
2022-03-21 10:00:00	QQQ	ETF	348.53	349.81	346.635	349.49	9093977.0
2022-03-21 11:00:00	QQQ	ETF	349.5	352.1594	348.97	351.8109	7269845.0
2022-03-21 12:00:00	QQQ	ETF	351.8717	352.025	347.08	347.235	8077099.0
2022-03-21 13:00:00	QQQ	ETF	347.3	347.65	345.575	347.48	6992943.0
2022-03-21 14:00:00	QQQ	ETF	347.47	349.42	346.67	347.25	5672651.0
2022-03-21 15:00:00	QQQ	ETF	347.23	350.18	347.02	350.12	9401707.0
2022-03-21 16:00:00	QQQ	ETF	350.14	350.76	350.0	350.59	2038006.0
2022-03-21 17:00:00	QQQ	ETF	350.68	350.75	350.08	350.58	456633.0
2022-03-21 18:00:00	QQQ	ETF	350.47	350.5	350.0	350.1	102367.0
2022-03-21 19:00:00	QQQ	ETF	350.05	350.21	349.41	349.42	99261.0
2022-03-21 04:00:00	IWM	ETF	206.5	206.87	206.44	206.62	24657.0
2022-03-21 05:00:00	IWM	ETF	206.68	206.93	206.31	206.53	9337.0
2022-03-21 06:00:00	IWM	ETF	206.53	206.63	206.27	206.32	10019.0
2022-03-21 07:00:00	IWM	ETF	206.54	207.02	206.46	206.9	24076.0
2022-03-21 08:00:00	IWM	ETF	206.6601	207.27	206.61	207.19	26456.0
2022-03-21 09:00:00	IWM	ETF	207.21	208.18	205.7	206.23	3554848.0
2022-03-21 10:00:00	IWM	ETF	206.19	206.85	205.74	206.672	3189453.0
2022-03-21 11:00:00	IWM	ETF	206.67	206.7598	205.76	206.56	2573447.0
2022-03-21 12:00:00	IWM	ETF	206.58	207.125	205.23	205.35	1460007.0
2022-03-21 13:00:00	IWM	ETF	205.36	205.5	204.17	204.91	1551655.0
2022-03-21 14:00:00	IWM	ETF	204.89	205.24	204.21	204.22	1397333.0
2022-03-21 15:00:00	IWM	ETF	204.22	205.43	203.935	205.41	3418371.0
2022-03-21 16:00:00	IWM	ETF	205.42	206.55	204.55	205.6	1070446.0
2022-03-21 17:00:00	IWM	ETF	205.7	205.82	205.29	205.45	33260.0
2022-03-21 18:00:00	IWM	ETF	205.44	205.46	205.13	205.15	30893.0
2022-03-21 19:00:00	IWM	ETF	205.1	205.17	204.78	204.78	60624.0
2022-03-21 04:00:00	DIA	ETF	346.5	346.53	346.25	346.53	5026.0
2022-03-21 05:00:00	DIA	ETF	345.99	346.63	345.99	346.34	1398.0

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

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