PREVIEW / etf_1hour / 2020-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-14.parquet
  size:    370 KB
  rows:    12,515

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-10-14 04:00:00	SPY	ETF	351.6	352.28	351.53	351.97	21931.0
2020-10-14 05:00:00	SPY	ETF	351.97	352.02	351.1	351.26	15110.0
2020-10-14 06:00:00	SPY	ETF	351.24	351.42	349.35	349.69	78854.0
2020-10-14 07:00:00	SPY	ETF	349.71	350.45	349.68	350.08	160142.0
2020-10-14 08:00:00	SPY	ETF	350.11	351.94	349.74	351.06	283229.0
2020-10-14 09:00:00	SPY	ETF	351.09	351.93	350.42	351.725	3744659.0
2020-10-14 10:00:00	SPY	ETF	351.73	351.8	349.78	350.6714	6058947.0
2020-10-14 11:00:00	SPY	ETF	350.68	350.9	348.04	348.18	7936746.0
2020-10-14 12:00:00	SPY	ETF	348.19	349.02	347.14	347.99	7735304.0
2020-10-14 13:00:00	SPY	ETF	347.95	348.47	347.21	348.11	5143864.0
2020-10-14 14:00:00	SPY	ETF	348.106	348.76	347.2	348.14	5664239.0
2020-10-14 15:00:00	SPY	ETF	348.14	349.3	347.785	347.97	12781477.0
2020-10-14 16:00:00	SPY	ETF	347.97	348.21	347.76	347.91	6973842.0
2020-10-14 17:00:00	SPY	ETF	347.96	348.04	347.85	347.95	173964.0
2020-10-14 18:00:00	SPY	ETF	347.95	348.55	347.39	348.15	208691.0
2020-10-14 19:00:00	SPY	ETF	348.17	348.53	348.1	348.37	80536.0
2020-10-14 04:00:00	QQQ	ETF	296.36	296.62	295.94	296.05	30954.0
2020-10-14 05:00:00	QQQ	ETF	296.27	296.32	295.25	295.43	23112.0
2020-10-14 06:00:00	QQQ	ETF	295.49	295.65	294.25	294.67	90882.0
2020-10-14 07:00:00	QQQ	ETF	294.73	295.71	294.65	295.37	134466.0
2020-10-14 08:00:00	QQQ	ETF	294.91	296.75	294.52	295.67	174563.0
2020-10-14 09:00:00	QQQ	ETF	295.65	296.35	294.38	295.822	3042042.0
2020-10-14 10:00:00	QQQ	ETF	295.88	295.995	293.32	294.84	4179563.0
2020-10-14 11:00:00	QQQ	ETF	294.85	295.18	291.78	291.95	3486938.0
2020-10-14 12:00:00	QQQ	ETF	292.0	292.54	290.26	291.22	5720736.0
2020-10-14 13:00:00	QQQ	ETF	291.2	291.98	290.405	291.88	4087897.0
2020-10-14 14:00:00	QQQ	ETF	291.86	292.74	291.17	292.06	4199862.0
2020-10-14 15:00:00	QQQ	ETF	292.09	293.47	291.76	292.14	5456007.0
2020-10-14 16:00:00	QQQ	ETF	292.12	294.0032	291.26	291.28	1387479.0
2020-10-14 17:00:00	QQQ	ETF	291.26	292.06	291.25	291.42	235335.0
2020-10-14 18:00:00	QQQ	ETF	291.42	292.19	291.0	291.66	202802.0
2020-10-14 19:00:00	QQQ	ETF	291.77	292.06	291.59	291.7	94864.0
2020-10-14 04:00:00	IWM	ETF	163.07	163.59	162.96	163.46	13114.0
2020-10-14 05:00:00	IWM	ETF	163.42	163.51	163.14	163.14	7356.0
2020-10-14 06:00:00	IWM	ETF	162.9	162.9	161.95	162.18	29760.0
2020-10-14 07:00:00	IWM	ETF	162.15	162.45	162.07	162.32	196168.0
2020-10-14 08:00:00	IWM	ETF	162.22	163.0	162.16	162.95	133941.0
2020-10-14 09:00:00	IWM	ETF	162.88	163.909	162.72	163.67	2318445.0
2020-10-14 10:00:00	IWM	ETF	163.68	163.68	162.43	162.72	2323451.0
2020-10-14 11:00:00	IWM	ETF	162.74	163.09	161.98	162.08	1810774.0
2020-10-14 12:00:00	IWM	ETF	162.07	162.6	161.54	162.04	1671234.0
2020-10-14 13:00:00	IWM	ETF	162.03	162.455	161.68	161.705	1529915.0
2020-10-14 14:00:00	IWM	ETF	161.69	161.94	161.02	161.4	2140831.0
2020-10-14 15:00:00	IWM	ETF	161.405	161.96	160.935	161.14	3661598.0
2020-10-14 16:00:00	IWM	ETF	161.09	161.41	160.89	161.39	847020.0
2020-10-14 17:00:00	IWM	ETF	161.44	161.44	161.23	161.31	6687.0
2020-10-14 18:00:00	IWM	ETF	161.38	161.67	161.17	161.58	38311.0
2020-10-14 19:00:00	IWM	ETF	161.61	161.73	161.55	161.61	9200.0
2020-10-14 04:00:00	DIA	ETF	287.76	288.31	287.72	288.31	8000.0
2020-10-14 05:00:00	DIA	ETF	287.75	287.75	287.69	287.69	300.0

> showing 50 of 12,515 rows — these rows as CSV

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