PREVIEW / etf_1hour / 2021-04-20

all etf 1-hour files

  file:    by_date/etf_1hour/2021/2021-04-20.parquet
  size:    424 KB
  rows:    14,663

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-20 04:00:00	SPY	ETF	415.66	415.72	415.0	415.08	39912.0
2021-04-20 05:00:00	SPY	ETF	415.02	415.02	413.35	413.55	76393.0
2021-04-20 06:00:00	SPY	ETF	413.54	413.75	412.68	413.55	99838.0
2021-04-20 07:00:00	SPY	ETF	413.57	413.73	413.25	413.63	236205.0
2021-04-20 08:00:00	SPY	ETF	413.4301	415.21	413.2204	413.6	697727.0
2021-04-20 09:00:00	SPY	ETF	413.6	414.68	413.6	414.34	4895081.0
2021-04-20 10:00:00	SPY	ETF	414.34	414.57	411.76	412.35	10911407.0
2021-04-20 11:00:00	SPY	ETF	412.35	412.51	410.62	411.46	11226457.0
2021-04-20 12:00:00	SPY	ETF	411.46	412.4	411.3009	412.03	5190322.0
2021-04-20 13:00:00	SPY	ETF	412.02	412.05	411.2	411.905	4870276.0
2021-04-20 14:00:00	SPY	ETF	411.895	412.1	410.59	410.849	4930214.0
2021-04-20 15:00:00	SPY	ETF	410.8499	412.67	410.84	412.24	11750971.0
2021-04-20 16:00:00	SPY	ETF	412.22	412.34	411.51	411.61	3847095.0
2021-04-20 17:00:00	SPY	ETF	411.6	412.17	411.59	411.76	79048.0
2021-04-20 18:00:00	SPY	ETF	411.77	412.17	411.66	411.99	67220.0
2021-04-20 19:00:00	SPY	ETF	411.93	411.971	411.64	411.8	44018.0
2021-04-20 04:00:00	QQQ	ETF	339.2	339.61	338.91	338.91	57034.0
2021-04-20 05:00:00	QQQ	ETF	339.01	339.11	337.11	337.34	87470.0
2021-04-20 06:00:00	QQQ	ETF	337.52	337.79	336.74	337.64	110865.0
2021-04-20 07:00:00	QQQ	ETF	337.64	338.01	337.29	337.85	105002.0
2021-04-20 08:00:00	QQQ	ETF	337.86	339.19	337.0696	337.69	178520.0
2021-04-20 09:00:00	QQQ	ETF	337.7	339.52	337.65	338.921	3808754.0
2021-04-20 10:00:00	QQQ	ETF	338.92	339.16	336.03	336.48	6649473.0
2021-04-20 11:00:00	QQQ	ETF	336.465	336.92	334.3816	335.57	7234614.0
2021-04-20 12:00:00	QQQ	ETF	335.58	336.5084	335.36	335.85	3146681.0
2021-04-20 13:00:00	QQQ	ETF	335.83	336.3	334.91	336.26	3504764.0
2021-04-20 14:00:00	QQQ	ETF	336.24	336.4	334.75	334.98	2384017.0
2021-04-20 15:00:00	QQQ	ETF	335.0	336.79	335.0	336.31	4180379.0
2021-04-20 16:00:00	QQQ	ETF	336.34	336.54	334.66	334.75	1445861.0
2021-04-20 17:00:00	QQQ	ETF	334.63	335.15	334.62	335.03	71107.0
2021-04-20 18:00:00	QQQ	ETF	335.03	335.25	334.9	335.16	62666.0
2021-04-20 19:00:00	QQQ	ETF	335.19	335.22	334.84	335.05	107850.0
2021-04-20 04:00:00	IWM	ETF	221.6	221.75	221.2	221.2	1955.0
2021-04-20 05:00:00	IWM	ETF	221.12	221.12	219.64	219.81	58530.0
2021-04-20 06:00:00	IWM	ETF	219.79	220.45	219.44	220.39	37347.0
2021-04-20 07:00:00	IWM	ETF	220.33	220.51	220.0	220.23	120702.0
2021-04-20 08:00:00	IWM	ETF	220.2101	222.04	220.06	220.55	90253.0
2021-04-20 09:00:00	IWM	ETF	220.62	221.43	219.81	219.98	2332167.0
2021-04-20 10:00:00	IWM	ETF	219.98	220.315	216.15	217.01	7078538.0
2021-04-20 11:00:00	IWM	ETF	217.01	217.16	215.24	216.77	5089029.0
2021-04-20 12:00:00	IWM	ETF	216.79	217.42	216.26	216.8	2678638.0
2021-04-20 13:00:00	IWM	ETF	216.8	216.86	215.62	216.14	2112106.0
2021-04-20 14:00:00	IWM	ETF	216.14	216.53	215.34	215.57	2376288.0
2021-04-20 15:00:00	IWM	ETF	215.565	217.44	215.56	217.34	5276081.0
2021-04-20 16:00:00	IWM	ETF	217.34	217.44	217.06	217.1	1947259.0
2021-04-20 17:00:00	IWM	ETF	217.15	217.3	217.1	217.22	122989.0
2021-04-20 18:00:00	IWM	ETF	217.33	217.68	217.19	217.57	47365.0
2021-04-20 19:00:00	IWM	ETF	217.51	217.58	217.13	217.35	36982.0
2021-04-20 04:00:00	DIA	ETF	340.63	340.63	340.18	340.38	2000.0
2021-04-20 05:00:00	DIA	ETF	340.1	340.1	339.06	339.28	5085.0

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

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