PREVIEW / etf_1hour / 2022-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2022/2022-04-12.parquet
  size:    456 KB
  rows:    16,508

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-04-12 04:00:00	SPY	ETF	438.59	440.0	438.08	439.7	65289.0
2022-04-12 05:00:00	SPY	ETF	439.64	440.2	439.32	439.96	39952.0
2022-04-12 06:00:00	SPY	ETF	439.98	440.52	439.69	440.44	89012.0
2022-04-12 07:00:00	SPY	ETF	440.1	440.57	439.66	440.53	132890.0
2022-04-12 08:00:00	SPY	ETF	440.44	445.33	437.5	444.79	2420533.0
2022-04-12 09:00:00	SPY	ETF	444.74	445.75	442.37	445.06	8700566.0
2022-04-12 10:00:00	SPY	ETF	445.07	445.3	442.22	442.63	9228438.0
2022-04-12 11:00:00	SPY	ETF	442.62	444.5	442.2199	443.68	6282337.0
2022-04-12 12:00:00	SPY	ETF	443.69	443.75	441.23	442.02	6338656.0
2022-04-12 13:00:00	SPY	ETF	442.01	442.7	439.39	439.6099	7114090.0
2022-04-12 14:00:00	SPY	ETF	439.58	440.34	437.97	438.83	10145242.0
2022-04-12 15:00:00	SPY	ETF	438.81	439.03	436.6501	438.24	17427581.0
2022-04-12 16:00:00	SPY	ETF	438.25	438.84	437.87	438.59	2866592.0
2022-04-12 17:00:00	SPY	ETF	438.6499	438.72	438.29	438.71	66996.0
2022-04-12 18:00:00	SPY	ETF	438.71	439.09	438.4	439.07	91287.0
2022-04-12 19:00:00	SPY	ETF	439.14	439.7	439.14	439.7	131083.0
2022-04-12 04:00:00	QQQ	ETF	340.0	341.44	339.86	341.17	164892.0
2022-04-12 05:00:00	QQQ	ETF	341.14	342.0	340.66	341.71	72062.0
2022-04-12 06:00:00	QQQ	ETF	341.94	342.0	341.11	341.35	82768.0
2022-04-12 07:00:00	QQQ	ETF	341.32	341.76	340.65	341.76	263451.0
2022-04-12 08:00:00	QQQ	ETF	341.33	347.83	338.81	347.28	3276860.0
2022-04-12 09:00:00	QQQ	ETF	347.28	347.45	343.685	347.25	9510466.0
2022-04-12 10:00:00	QQQ	ETF	347.26	347.69	343.0791	343.78	9032080.0
2022-04-12 11:00:00	QQQ	ETF	343.76	345.86	343.01	344.71	7049777.0
2022-04-12 12:00:00	QQQ	ETF	344.72	344.76	342.44	343.44	5911899.0
2022-04-12 13:00:00	QQQ	ETF	343.41	344.16	340.86	341.04	5521531.0
2022-04-12 14:00:00	QQQ	ETF	341.04	341.6994	338.88	339.77	7555723.0
2022-04-12 15:00:00	QQQ	ETF	339.75	340.35	338.035	339.52	10662029.0
2022-04-12 16:00:00	QQQ	ETF	339.51	339.99	339.01	339.78	1648184.0
2022-04-12 17:00:00	QQQ	ETF	339.89	339.89	339.45	339.85	63908.0
2022-04-12 18:00:00	QQQ	ETF	339.89	340.11	339.51	340.09	107765.0
2022-04-12 19:00:00	QQQ	ETF	340.09	340.86	340.08	340.86	216880.0
2022-04-12 04:00:00	IWM	ETF	195.84	196.69	195.66	196.67	19623.0
2022-04-12 05:00:00	IWM	ETF	196.52	196.69	196.42	196.64	6600.0
2022-04-12 06:00:00	IWM	ETF	196.6	196.87	196.43	196.77	39482.0
2022-04-12 07:00:00	IWM	ETF	196.77	197.17	196.62	197.07	190194.0
2022-04-12 08:00:00	IWM	ETF	196.8687	199.46	195.7	199.18	467166.0
2022-04-12 09:00:00	IWM	ETF	199.13	201.4	198.41	201.27	4685208.0
2022-04-12 10:00:00	IWM	ETF	201.27	201.68	199.385	200.01	4552699.0
2022-04-12 11:00:00	IWM	ETF	200.0	200.71	199.72	200.17	2498071.0
2022-04-12 12:00:00	IWM	ETF	200.19	200.21	198.83	199.09	1910772.0
2022-04-12 13:00:00	IWM	ETF	199.08	199.49	197.69	197.85	2287610.0
2022-04-12 14:00:00	IWM	ETF	197.825	198.255	196.86	197.2	2612829.0
2022-04-12 15:00:00	IWM	ETF	197.185	197.53	196.42	197.13	4122138.0
2022-04-12 16:00:00	IWM	ETF	197.13	197.58	196.95	197.27	1444976.0
2022-04-12 17:00:00	IWM	ETF	197.16	197.49	197.16	197.49	63719.0
2022-04-12 18:00:00	IWM	ETF	197.35	197.73	197.25	197.66	19239.0
2022-04-12 19:00:00	IWM	ETF	197.7596	197.97	197.62	197.93	15650.0
2022-04-12 04:00:00	DIA	ETF	341.75	343.08	341.58	343.08	3800.0
2022-04-12 05:00:00	DIA	ETF	342.74	343.07	342.74	343.07	300.0

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

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