PREVIEW / etf_1hour / 2020-09-21

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-21.parquet
  size:    392 KB
  rows:    13,530

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
2020-09-21 04:00:00	SPY	ETF	328.14	328.14	324.65	325.34	166657.0
2020-09-21 05:00:00	SPY	ETF	325.33	326.84	325.0	325.49	137740.0
2020-09-21 06:00:00	SPY	ETF	325.55	326.71	325.37	326.4	196875.0
2020-09-21 07:00:00	SPY	ETF	326.46	326.76	325.43	326.7	477727.0
2020-09-21 08:00:00	SPY	ETF	326.3499	331.04	324.81	325.8	957798.0
2020-09-21 09:00:00	SPY	ETF	325.75	326.5	323.67	325.24	11210948.0
2020-09-21 10:00:00	SPY	ETF	325.22	325.58	321.73	322.7	18137096.0
2020-09-21 11:00:00	SPY	ETF	322.69	323.858	321.89	323.62	10401941.0
2020-09-21 12:00:00	SPY	ETF	323.62	324.55	323.005	323.27	7430814.0
2020-09-21 13:00:00	SPY	ETF	323.27	324.8	322.62	323.64	8451125.0
2020-09-21 14:00:00	SPY	ETF	323.65	323.88	322.16	323.41	11277163.0
2020-09-21 15:00:00	SPY	ETF	323.42	327.09	323.305	327.0	19947435.0
2020-09-21 16:00:00	SPY	ETF	327.02	331.165	326.949	327.32	8188016.0
2020-09-21 17:00:00	SPY	ETF	327.39	327.43	326.9	327.04	330978.0
2020-09-21 18:00:00	SPY	ETF	327.05	327.54	326.95	327.47	391492.0
2020-09-21 19:00:00	SPY	ETF	327.45	328.2	327.22	328.1	111019.0
2020-09-21 04:00:00	QQQ	ETF	264.5	264.54	261.79	262.19	179727.0
2020-09-21 05:00:00	QQQ	ETF	262.14	263.68	261.39	262.02	124499.0
2020-09-21 06:00:00	QQQ	ETF	262.25	263.52	261.9	263.26	69793.0
2020-09-21 07:00:00	QQQ	ETF	263.25	263.58	261.56	263.39	371091.0
2020-09-21 08:00:00	QQQ	ETF	262.9399	266.44	261.7098	262.72	883163.0
2020-09-21 09:00:00	QQQ	ETF	262.68	264.6	261.25	263.6692	7745123.0
2020-09-21 10:00:00	QQQ	ETF	263.64	264.1	260.11	261.49	7350321.0
2020-09-21 11:00:00	QQQ	ETF	261.5	263.68	261.0	263.6055	4933016.0
2020-09-21 12:00:00	QQQ	ETF	263.6237	264.83	263.5	263.83	4756638.0
2020-09-21 13:00:00	QQQ	ETF	263.83	265.61	263.23	264.26	4746411.0
2020-09-21 14:00:00	QQQ	ETF	264.25	264.67	262.465	263.94	4414230.0
2020-09-21 15:00:00	QQQ	ETF	263.94	267.65	263.81	267.54	8512856.0
2020-09-21 16:00:00	QQQ	ETF	267.55	268.63	267.51	267.99	1195376.0
2020-09-21 17:00:00	QQQ	ETF	268.06	268.15	267.24	267.5	207568.0
2020-09-21 18:00:00	QQQ	ETF	267.55	268.04	267.4	268.0	105812.0
2020-09-21 19:00:00	QQQ	ETF	268.0	268.79	267.74	268.71	126831.0
2020-09-21 04:00:00	IWM	ETF	151.49	151.49	149.5	149.86	58803.0
2020-09-21 05:00:00	IWM	ETF	150.09	150.73	149.8	150.12	19565.0
2020-09-21 06:00:00	IWM	ETF	150.16	150.48	150.05	150.15	84558.0
2020-09-21 07:00:00	IWM	ETF	150.25	150.52	150.09	150.51	108269.0
2020-09-21 08:00:00	IWM	ETF	150.33	152.42	149.1	149.66	197202.0
2020-09-21 09:00:00	IWM	ETF	149.63	150.255	148.1925	149.24	4324588.0
2020-09-21 10:00:00	IWM	ETF	149.22	149.335	146.76	147.49	5676133.0
2020-09-21 11:00:00	IWM	ETF	147.5	148.15	146.76	147.48	3865349.0
2020-09-21 12:00:00	IWM	ETF	147.48	147.8	146.57	146.78	2782480.0
2020-09-21 13:00:00	IWM	ETF	146.78	147.45	146.515	146.76	2842673.0
2020-09-21 14:00:00	IWM	ETF	146.76	147.015	146.33	146.91	3141316.0
2020-09-21 15:00:00	IWM	ETF	146.9	148.04	146.84	148.01	7393190.0
2020-09-21 16:00:00	IWM	ETF	147.92	148.5	147.92	148.07	2075600.0
2020-09-21 17:00:00	IWM	ETF	148.0	148.35	147.92	147.92	15098.0
2020-09-21 18:00:00	IWM	ETF	148.03	148.39	148.03	148.21	11033.0
2020-09-21 19:00:00	IWM	ETF	148.31	148.56	148.28	148.56	43085.0
2020-09-21 04:00:00	DIA	ETF	274.0	274.0	270.7	270.7	3534.0
2020-09-21 05:00:00	DIA	ETF	271.67	272.62	271.28	271.28	4842.0

> showing 50 of 13,530 rows — these rows as CSV

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