PREVIEW / etf_1hour / 2021-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-25.parquet
  size:    396 KB
  rows:    14,447

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-05-25 04:00:00	SPY	ETF	420.26	420.44	420.1	420.39	8858.0
2021-05-25 05:00:00	SPY	ETF	420.39	420.5	420.37	420.47	21358.0
2021-05-25 06:00:00	SPY	ETF	420.51	420.64	420.05	420.12	19787.0
2021-05-25 07:00:00	SPY	ETF	420.12	420.59	420.03	420.5	77947.0
2021-05-25 08:00:00	SPY	ETF	420.03	420.56	419.9	420.24	190332.0
2021-05-25 09:00:00	SPY	ETF	420.28	420.71	419.24	419.3	6314379.0
2021-05-25 10:00:00	SPY	ETF	419.29	419.66	418.9401	419.44	5752119.0
2021-05-25 11:00:00	SPY	ETF	419.435	419.5	417.94	418.85	6156963.0
2021-05-25 12:00:00	SPY	ETF	418.86	419.44	418.71	419.1119	3452434.0
2021-05-25 13:00:00	SPY	ETF	419.1	419.22	418.38	418.76	3710970.0
2021-05-25 14:00:00	SPY	ETF	418.76	418.83	418.2	418.359	4586913.0
2021-05-25 15:00:00	SPY	ETF	418.35	418.73	417.62	418.25	11308157.0
2021-05-25 16:00:00	SPY	ETF	418.26	418.57	418.16	418.51	1821077.0
2021-05-25 17:00:00	SPY	ETF	418.52	418.57	418.4	418.54	82377.0
2021-05-25 18:00:00	SPY	ETF	418.49	419.14	418.24	419.06	82231.0
2021-05-25 19:00:00	SPY	ETF	419.09	419.11	418.91	419.11	40835.0
2021-05-25 04:00:00	QQQ	ETF	334.06	334.51	333.95	334.26	51103.0
2021-05-25 05:00:00	QQQ	ETF	334.26	334.48	334.09	334.46	30615.0
2021-05-25 06:00:00	QQQ	ETF	334.44	334.59	333.66	333.78	72363.0
2021-05-25 07:00:00	QQQ	ETF	333.73	334.47	333.47	334.33	123178.0
2021-05-25 08:00:00	QQQ	ETF	333.51	334.98	333.3	334.08	245560.0
2021-05-25 09:00:00	QQQ	ETF	334.08	334.81	332.85	332.86	4714633.0
2021-05-25 10:00:00	QQQ	ETF	332.86	333.7	332.47	333.5398	4956898.0
2021-05-25 11:00:00	QQQ	ETF	333.5398	333.61	331.755	332.64	4206009.0
2021-05-25 12:00:00	QQQ	ETF	332.645	332.9801	332.31	332.55	2194090.0
2021-05-25 13:00:00	QQQ	ETF	332.54	333.098	331.98	332.79	2209183.0
2021-05-25 14:00:00	QQQ	ETF	332.8	332.9	332.2001	332.6667	2149614.0
2021-05-25 15:00:00	QQQ	ETF	332.65	333.02	332.07	332.95	3951400.0
2021-05-25 16:00:00	QQQ	ETF	332.97	333.26	332.81	333.24	599106.0
2021-05-25 17:00:00	QQQ	ETF	333.28	333.29	332.97	333.14	35521.0
2021-05-25 18:00:00	QQQ	ETF	333.17	334.0	333.14	333.9	121308.0
2021-05-25 19:00:00	QQQ	ETF	333.9	333.93	333.65	333.87	48698.0
2021-05-25 04:00:00	IWM	ETF	221.84	222.05	221.68	222.05	6877.0
2021-05-25 05:00:00	IWM	ETF	222.0	222.1	221.99	222.1	15850.0
2021-05-25 06:00:00	IWM	ETF	222.1	222.1	221.72	221.89	4490.0
2021-05-25 07:00:00	IWM	ETF	221.89	222.34	221.89	222.2	48189.0
2021-05-25 08:00:00	IWM	ETF	222.0999	222.29	221.8104	222.0	82322.0
2021-05-25 09:00:00	IWM	ETF	222.01	223.71	221.7	221.84	3045121.0
2021-05-25 10:00:00	IWM	ETF	221.83	222.48	221.43	222.12	2251445.0
2021-05-25 11:00:00	IWM	ETF	222.12	222.16	219.8601	221.17	2543298.0
2021-05-25 12:00:00	IWM	ETF	221.18	221.37	220.83	221.17	1003352.0
2021-05-25 13:00:00	IWM	ETF	221.15	221.31	220.73	220.97	1050382.0
2021-05-25 14:00:00	IWM	ETF	220.98	221.03	219.94	219.995	1379557.0
2021-05-25 15:00:00	IWM	ETF	219.99	220.32	219.19	219.26	3702118.0
2021-05-25 16:00:00	IWM	ETF	219.26	219.7	219.16	219.66	1327163.0
2021-05-25 17:00:00	IWM	ETF	219.41	219.58	219.26	219.43	18413.0
2021-05-25 18:00:00	IWM	ETF	219.58	220.03	219.26	220.0	56400.0
2021-05-25 19:00:00	IWM	ETF	219.92	219.96	219.84	219.96	5076.0
2021-05-25 04:00:00	DIA	ETF	344.76	344.76	344.76	344.76	270.0
2021-05-25 05:00:00	DIA	ETF	344.81	344.81	344.72	344.72	800.0

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

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