PREVIEW / etf_1hour / 2021-04-22

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-22.parquet
  size:    414 KB
  rows:    14,342

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
2021-04-22 04:00:00	SPY	ETF	415.61	416.02	415.52	415.6	40861.0
2021-04-22 05:00:00	SPY	ETF	415.62	415.87	415.54	415.85	18597.0
2021-04-22 06:00:00	SPY	ETF	415.9	415.9	415.4	415.55	19067.0
2021-04-22 07:00:00	SPY	ETF	415.53	415.73	415.4	415.52	109580.0
2021-04-22 08:00:00	SPY	ETF	415.5099	416.14	415.41	415.85	394971.0
2021-04-22 09:00:00	SPY	ETF	415.83	416.16	414.715	415.3	5834308.0
2021-04-22 10:00:00	SPY	ETF	415.295	416.16	414.535	415.86	6850669.0
2021-04-22 11:00:00	SPY	ETF	415.86	416.45	415.71	416.075	4197401.0
2021-04-22 12:00:00	SPY	ETF	416.075	416.76	415.77	416.75	3810955.0
2021-04-22 13:00:00	SPY	ETF	416.75	416.78	411.5	411.82	23750929.0
2021-04-22 14:00:00	SPY	ETF	411.83	413.45	411.13	412.995	13345284.0
2021-04-22 15:00:00	SPY	ETF	413.0	413.44	411.7599	412.32	17814642.0
2021-04-22 16:00:00	SPY	ETF	412.33	412.6	411.99	412.58	3523726.0
2021-04-22 17:00:00	SPY	ETF	412.57	412.58	412.2999	412.35	68065.0
2021-04-22 18:00:00	SPY	ETF	412.37	412.86	412.27	412.81	154130.0
2021-04-22 19:00:00	SPY	ETF	412.8	412.85	412.42	412.59	45926.0
2021-04-22 04:00:00	QQQ	ETF	339.22	339.51	339.14	339.22	36909.0
2021-04-22 05:00:00	QQQ	ETF	339.21	339.36	338.92	339.14	22257.0
2021-04-22 06:00:00	QQQ	ETF	339.15	339.17	338.44	338.79	34260.0
2021-04-22 07:00:00	QQQ	ETF	338.8	338.99	338.45	338.63	127452.0
2021-04-22 08:00:00	QQQ	ETF	338.82	339.6	338.4	338.8996	214386.0
2021-04-22 09:00:00	QQQ	ETF	338.88	339.18	337.752	338.41	3396612.0
2021-04-22 10:00:00	QQQ	ETF	338.4	339.9	337.79	339.42	4485541.0
2021-04-22 11:00:00	QQQ	ETF	339.43	339.629	338.7501	339.01	2535424.0
2021-04-22 12:00:00	QQQ	ETF	339.04	339.835	338.63	339.7713	1981127.0
2021-04-22 13:00:00	QQQ	ETF	339.78	339.86	334.36	334.78	11492907.0
2021-04-22 14:00:00	QQQ	ETF	334.77	336.2	334.01	335.48	6568448.0
2021-04-22 15:00:00	QQQ	ETF	335.49	336.0473	334.531	335.22	7095461.0
2021-04-22 16:00:00	QQQ	ETF	335.21	335.51	334.8	335.49	821036.0
2021-04-22 17:00:00	QQQ	ETF	335.49	335.6	335.2	335.38	85968.0
2021-04-22 18:00:00	QQQ	ETF	335.39	335.7	335.18	335.64	73124.0
2021-04-22 19:00:00	QQQ	ETF	335.68	335.72	335.2699	335.44	51454.0
2021-04-22 04:00:00	IWM	ETF	221.79	221.94	221.73	221.83	6113.0
2021-04-22 05:00:00	IWM	ETF	221.49	221.89	221.43	221.89	8142.0
2021-04-22 06:00:00	IWM	ETF	221.97	222.04	221.67	221.67	19500.0
2021-04-22 07:00:00	IWM	ETF	221.68	221.69	221.38	221.54	82923.0
2021-04-22 08:00:00	IWM	ETF	221.55	222.75	221.55	222.53	128257.0
2021-04-22 09:00:00	IWM	ETF	222.51	223.6	221.48	222.51	4007574.0
2021-04-22 10:00:00	IWM	ETF	222.45	223.49	221.52	223.32	2900144.0
2021-04-22 11:00:00	IWM	ETF	223.31	225.02	223.31	224.95	3723455.0
2021-04-22 12:00:00	IWM	ETF	224.955	225.33	224.32	225.31	1569544.0
2021-04-22 13:00:00	IWM	ETF	225.3	225.3	221.22	221.48	5795035.0
2021-04-22 14:00:00	IWM	ETF	221.48	223.25	220.78	222.82	3164166.0
2021-04-22 15:00:00	IWM	ETF	222.86	223.227	221.47	221.62	4580188.0
2021-04-22 16:00:00	IWM	ETF	221.58	222.21	221.58	222.21	1017315.0
2021-04-22 17:00:00	IWM	ETF	221.85	222.16	221.58	222.07	40169.0
2021-04-22 18:00:00	IWM	ETF	222.06	222.5	221.94	222.41	77233.0
2021-04-22 19:00:00	IWM	ETF	222.39	222.54	222.3	222.31	29566.0
2021-04-22 04:00:00	DIA	ETF	341.1	341.11	341.1	341.11	795.0
2021-04-22 05:00:00	DIA	ETF	340.94	340.94	340.94	340.94	1300.0

> showing 50 of 14,342 rows — these rows as CSV

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