PREVIEW / etf_1hour / 2021-05-04

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-05-04.parquet
  size:    430 KB
  rows:    14,996

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-04 04:00:00	SPY	ETF	417.2	417.73	417.02	417.43	16768.0
2021-05-04 05:00:00	SPY	ETF	417.36	417.88	417.28	417.78	11978.0
2021-05-04 06:00:00	SPY	ETF	417.78	417.96	417.56	417.79	8445.0
2021-05-04 07:00:00	SPY	ETF	417.83	417.94	415.82	416.49	1050709.0
2021-05-04 08:00:00	SPY	ETF	417.7701	418.0	415.36	415.94	780638.0
2021-05-04 09:00:00	SPY	ETF	415.95	416.6	413.75	413.88	9976729.0
2021-05-04 10:00:00	SPY	ETF	413.88	414.5899	413.15	413.276	13043778.0
2021-05-04 11:00:00	SPY	ETF	413.28	413.74	411.67	412.122	12869983.0
2021-05-04 12:00:00	SPY	ETF	412.125	413.51	411.98	412.8	6992986.0
2021-05-04 13:00:00	SPY	ETF	412.78	413.9799	412.6	413.51	6471996.0
2021-05-04 14:00:00	SPY	ETF	413.5	414.4	413.19	414.07	6344675.0
2021-05-04 15:00:00	SPY	ETF	414.0719	415.66	413.481	415.65	18695916.0
2021-05-04 16:00:00	SPY	ETF	415.65	415.82	415.0	415.44	3377362.0
2021-05-04 17:00:00	SPY	ETF	415.49	415.59	415.41	415.52	66062.0
2021-05-04 18:00:00	SPY	ETF	415.52	415.55	415.16	415.398	81524.0
2021-05-04 19:00:00	SPY	ETF	415.4	415.62	415.3	415.58	97420.0
2021-05-04 04:00:00	QQQ	ETF	335.0	335.51	334.63	334.91	67617.0
2021-05-04 05:00:00	QQQ	ETF	334.94	335.34	334.75	335.29	12302.0
2021-05-04 06:00:00	QQQ	ETF	335.35	335.5	334.77	335.05	27356.0
2021-05-04 07:00:00	QQQ	ETF	335.07	335.28	332.81	333.71	590765.0
2021-05-04 08:00:00	QQQ	ETF	333.71	335.66	332.91	333.58	555923.0
2021-05-04 09:00:00	QQQ	ETF	333.55	333.89	329.96	330.15	10642679.0
2021-05-04 10:00:00	QQQ	ETF	330.16	330.38	328.41	328.57	10871162.0
2021-05-04 11:00:00	QQQ	ETF	328.58	329.02	326.21	326.73	8891475.0
2021-05-04 12:00:00	QQQ	ETF	326.72	327.93	326.54	326.96	5065300.0
2021-05-04 13:00:00	QQQ	ETF	326.93	328.22	326.82	327.61	3901434.0
2021-05-04 14:00:00	QQQ	ETF	327.54	328.8918	327.25	328.62	3698156.0
2021-05-04 15:00:00	QQQ	ETF	328.601	330.15	327.97	330.15	8265360.0
2021-05-04 16:00:00	QQQ	ETF	330.17	330.37	329.48	329.63	1862313.0
2021-05-04 17:00:00	QQQ	ETF	329.39	330.14	329.39	329.75	162282.0
2021-05-04 18:00:00	QQQ	ETF	329.78	329.79	329.339	329.61	125740.0
2021-05-04 19:00:00	QQQ	ETF	329.65	330.14	329.42	329.73	91402.0
2021-05-04 04:00:00	IWM	ETF	225.19	225.59	225.08	225.5	12200.0
2021-05-04 05:00:00	IWM	ETF	225.41	225.79	225.4	225.71	8520.0
2021-05-04 06:00:00	IWM	ETF	225.8	225.81	225.51	225.79	2419.0
2021-05-04 07:00:00	IWM	ETF	225.74	225.79	223.78	224.53	95336.0
2021-05-04 08:00:00	IWM	ETF	224.51	225.79	223.83	224.79	191420.0
2021-05-04 09:00:00	IWM	ETF	224.85	224.9	221.51	221.62	3804494.0
2021-05-04 10:00:00	IWM	ETF	221.65	223.64	220.955	222.24	4706057.0
2021-05-04 11:00:00	IWM	ETF	222.24	222.55	221.1501	221.59	3048074.0
2021-05-04 12:00:00	IWM	ETF	221.59	222.64	221.52	222.215	1489640.0
2021-05-04 13:00:00	IWM	ETF	222.215	222.97	221.9618	222.63	1912551.0
2021-05-04 14:00:00	IWM	ETF	222.64	223.14	222.22	222.62	1958264.0
2021-05-04 15:00:00	IWM	ETF	222.63	223.3	222.3	223.29	3370079.0
2021-05-04 16:00:00	IWM	ETF	223.29	223.39	222.96	223.35	708391.0
2021-05-04 17:00:00	IWM	ETF	223.29	223.35	223.29	223.35	126473.0
2021-05-04 18:00:00	IWM	ETF	223.35	223.64	223.32	223.45	42388.0
2021-05-04 19:00:00	IWM	ETF	223.45	223.62	223.4	223.62	8346.0
2021-05-04 04:00:00	DIA	ETF	340.76	341.08	340.75	340.88	1025.0
2021-05-04 05:00:00	DIA	ETF	340.99	341.24	340.99	341.24	1843.0

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

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