PREVIEW / etf_1hour / 2019-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-12.parquet
  size:    360 KB
  rows:    11,808

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
2019-12-12 04:00:00	SPY	ETF	314.99	315.28	314.99	315.19	17927.0
2019-12-12 05:00:00	SPY	ETF	315.22	315.27	314.8	314.82	8871.0
2019-12-12 06:00:00	SPY	ETF	314.85	314.95	314.78	314.94	30670.0
2019-12-12 07:00:00	SPY	ETF	314.95	314.95	314.54	314.6	156122.0
2019-12-12 08:00:00	SPY	ETF	314.8399	315.15	314.02	314.45	457278.0
2019-12-12 09:00:00	SPY	ETF	314.37	316.8698	314.17	316.845	11112857.0
2019-12-12 10:00:00	SPY	ETF	316.85	317.99	316.77	317.34	18154189.0
2019-12-12 11:00:00	SPY	ETF	317.35	317.41	315.61	316.16	8896096.0
2019-12-12 12:00:00	SPY	ETF	316.17	316.38	315.33	316.0	7042623.0
2019-12-12 13:00:00	SPY	ETF	316.0	316.53	315.97	316.2	4207811.0
2019-12-12 14:00:00	SPY	ETF	316.21	317.32	315.76	316.71	15195858.0
2019-12-12 15:00:00	SPY	ETF	316.71	317.68	316.62	317.14	18078223.0
2019-12-12 16:00:00	SPY	ETF	317.14	317.36	316.7	317.23	9371344.0
2019-12-12 17:00:00	SPY	ETF	317.24	317.8	317.17	317.6	1035383.0
2019-12-12 18:00:00	SPY	ETF	317.68	318.5	317.68	318.37	409600.0
2019-12-12 19:00:00	SPY	ETF	318.35	318.45	317.91	318.41	123317.0
2019-12-12 04:00:00	QQQ	ETF	205.47	205.66	205.47	205.55	13631.0
2019-12-12 05:00:00	QQQ	ETF	205.61	205.62	205.25	205.33	8555.0
2019-12-12 06:00:00	QQQ	ETF	205.33	205.4	205.27	205.38	8502.0
2019-12-12 07:00:00	QQQ	ETF	205.39	205.39	205.02	205.05	107120.0
2019-12-12 08:00:00	QQQ	ETF	205.3199	205.6341	204.56	204.89	718333.0
2019-12-12 09:00:00	QQQ	ETF	204.89	206.53	204.491	206.51	4831777.0
2019-12-12 10:00:00	QQQ	ETF	206.53	207.32	206.52	206.905	5237868.0
2019-12-12 11:00:00	QQQ	ETF	206.91	206.94	205.34	205.7101	4072393.0
2019-12-12 12:00:00	QQQ	ETF	205.72	205.85	205.0	205.61	3299071.0
2019-12-12 13:00:00	QQQ	ETF	205.61	206.08	205.6	205.93	1601548.0
2019-12-12 14:00:00	QQQ	ETF	205.92	206.57	205.42	206.07	4817512.0
2019-12-12 15:00:00	QQQ	ETF	206.08	206.9	205.935	206.58	3975054.0
2019-12-12 16:00:00	QQQ	ETF	206.57	206.76	206.29	206.69	1500759.0
2019-12-12 17:00:00	QQQ	ETF	206.72	207.0	206.62	206.87	82621.0
2019-12-12 18:00:00	QQQ	ETF	207.01	207.52	206.93	207.44	62643.0
2019-12-12 19:00:00	QQQ	ETF	207.5	207.59	207.22	207.59	59070.0
2019-12-12 04:00:00	IWM	ETF	163.03	163.24	163.03	163.17	900.0
2019-12-12 05:00:00	IWM	ETF	163.27	163.27	163.0	163.0	3600.0
2019-12-12 06:00:00	IWM	ETF	163.0	163.05	162.97	163.0	8800.0
2019-12-12 07:00:00	IWM	ETF	163.0	163.02	162.84	162.87	17519.0
2019-12-12 08:00:00	IWM	ETF	162.99	163.1	162.5	162.68	66001.0
2019-12-12 09:00:00	IWM	ETF	162.67	164.05	162.25	164.02	2232439.0
2019-12-12 10:00:00	IWM	ETF	164.02	165.1	164.02	164.42	4259446.0
2019-12-12 11:00:00	IWM	ETF	164.42	164.48	163.28	163.58	2256104.0
2019-12-12 12:00:00	IWM	ETF	163.57	163.8	163.11	163.52	1648104.0
2019-12-12 13:00:00	IWM	ETF	163.52	163.79	163.375	163.495	1293469.0
2019-12-12 14:00:00	IWM	ETF	163.495	164.31	163.33	164.035	3019371.0
2019-12-12 15:00:00	IWM	ETF	164.05	164.35	163.93	164.0	2994873.0
2019-12-12 16:00:00	IWM	ETF	163.96	164.15	163.64	163.91	1326307.0
2019-12-12 17:00:00	IWM	ETF	164.1	164.45	163.96	164.3	42398.0
2019-12-12 18:00:00	IWM	ETF	164.45	164.81	164.45	164.81	20302.0
2019-12-12 19:00:00	IWM	ETF	164.78	164.78	164.55	164.69	14403.0
2019-12-12 04:00:00	DIA	ETF	280.3	280.3	280.28	280.28	600.0
2019-12-12 05:00:00	DIA	ETF	280.16	280.16	280.16	280.16	500.0

> showing 50 of 11,808 rows — these rows as CSV

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