PREVIEW / etf_1hour / 2020-01-30

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-01-30.parquet
  size:    372 KB
  rows:    12,227

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-01-30 04:00:00	SPY	ETF	324.5	325.32	324.3	324.78	54238.0
2020-01-30 05:00:00	SPY	ETF	324.69	324.76	324.43	324.55	15687.0
2020-01-30 06:00:00	SPY	ETF	324.49	324.49	323.8	324.38	147029.0
2020-01-30 07:00:00	SPY	ETF	324.43	324.55	323.96	324.05	534950.0
2020-01-30 08:00:00	SPY	ETF	324.45	326.62	323.48	324.61	981438.0
2020-01-30 09:00:00	SPY	ETF	324.6	325.89	324.3	325.19	7154235.0
2020-01-30 10:00:00	SPY	ETF	325.19	326.6278	323.54	323.72	8728691.0
2020-01-30 11:00:00	SPY	ETF	323.73	325.6907	323.645	325.17	7789776.0
2020-01-30 12:00:00	SPY	ETF	325.18	325.35	323.86	324.27	8462755.0
2020-01-30 13:00:00	SPY	ETF	324.28	324.72	324.04	324.54	4494998.0
2020-01-30 14:00:00	SPY	ETF	324.55	326.17	324.2	325.88	12964944.0
2020-01-30 15:00:00	SPY	ETF	325.89	327.91	325.74	327.66	18599774.0
2020-01-30 16:00:00	SPY	ETF	327.65	328.9	326.6278	328.8	3507680.0
2020-01-30 17:00:00	SPY	ETF	328.77	328.77	328.16	328.49	273802.0
2020-01-30 18:00:00	SPY	ETF	328.5	328.61	328.25	328.3	195068.0
2020-01-30 19:00:00	SPY	ETF	328.36	328.6	327.85	328.6	105289.0
2020-01-30 04:00:00	QQQ	ETF	220.07	220.78	219.94	220.39	65394.0
2020-01-30 05:00:00	QQQ	ETF	220.32	220.39	220.04	220.13	32183.0
2020-01-30 06:00:00	QQQ	ETF	220.06	220.17	219.56	219.92	88855.0
2020-01-30 07:00:00	QQQ	ETF	220.07	220.29	219.88	219.99	221350.0
2020-01-30 08:00:00	QQQ	ETF	220.04	221.81	219.32	220.54	467710.0
2020-01-30 09:00:00	QQQ	ETF	220.53	221.89	220.19	221.14	3810075.0
2020-01-30 10:00:00	QQQ	ETF	221.14	221.74	219.7	219.75	5396847.0
2020-01-30 11:00:00	QQQ	ETF	219.75	221.33	219.6891	220.89	3118909.0
2020-01-30 12:00:00	QQQ	ETF	220.89	221.05	219.86	220.17	2689043.0
2020-01-30 13:00:00	QQQ	ETF	220.19	220.57	219.94	220.46	2119442.0
2020-01-30 14:00:00	QQQ	ETF	220.4661	221.91	220.39	221.495	5050338.0
2020-01-30 15:00:00	QQQ	ETF	221.5	222.7	221.35	222.6	6008592.0
2020-01-30 16:00:00	QQQ	ETF	222.58	224.9	222.5663	224.82	2280868.0
2020-01-30 17:00:00	QQQ	ETF	224.83	224.85	224.32	224.56	95796.0
2020-01-30 18:00:00	QQQ	ETF	224.57	224.61	224.3	224.41	97623.0
2020-01-30 19:00:00	QQQ	ETF	224.4	224.7	224.04	224.65	115779.0
2020-01-30 04:00:00	IWM	ETF	163.0	163.25	162.75	162.97	5291.0
2020-01-30 05:00:00	IWM	ETF	162.95	162.95	162.85	162.85	1566.0
2020-01-30 06:00:00	IWM	ETF	162.78	162.78	162.5	162.65	15949.0
2020-01-30 07:00:00	IWM	ETF	162.66	162.77	162.34	162.52	40897.0
2020-01-30 08:00:00	IWM	ETF	162.63	163.08	162.36	162.85	64454.0
2020-01-30 09:00:00	IWM	ETF	162.86	164.135	162.77	163.48	2557117.0
2020-01-30 10:00:00	IWM	ETF	163.485	163.75	161.93	162.02	2824999.0
2020-01-30 11:00:00	IWM	ETF	162.02	163.21	161.98	162.93	2039628.0
2020-01-30 12:00:00	IWM	ETF	162.92	163.053	162.05	162.21	1836086.0
2020-01-30 13:00:00	IWM	ETF	162.23	162.45	162.09	162.27	904258.0
2020-01-30 14:00:00	IWM	ETF	162.29	163.15	162.24	162.99	2356077.0
2020-01-30 15:00:00	IWM	ETF	162.99	164.01	162.91	163.96	3221772.0
2020-01-30 16:00:00	IWM	ETF	163.96	164.15	162.765	164.05	2568603.0
2020-01-30 17:00:00	IWM	ETF	164.1	164.11	163.92	164.05	91446.0
2020-01-30 18:00:00	IWM	ETF	164.05	164.05	163.69	163.86	17620.0
2020-01-30 19:00:00	IWM	ETF	163.73	163.9901	163.68	163.9901	12500.0
2020-01-30 04:00:00	DIA	ETF	286.08	286.16	285.68	286.16	1400.0
2020-01-30 05:00:00	DIA	ETF	285.78	285.78	285.78	285.78	100.0

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

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