PREVIEW / etf_1hour / 2019-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-14.parquet
  size:    312 KB
  rows:    10,420

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-06-14 04:00:00	SPY	ETF	289.38	289.39	288.87	289.09	17787.0
2019-06-14 05:00:00	SPY	ETF	289.07	289.2	288.84	288.99	33002.0
2019-06-14 06:00:00	SPY	ETF	288.96	288.96	288.52	288.81	68079.0
2019-06-14 07:00:00	SPY	ETF	288.84	289.23	288.81	289.2	147435.0
2019-06-14 08:00:00	SPY	ETF	288.95	290.07	288.8501	289.16	428821.0
2019-06-14 09:00:00	SPY	ETF	289.14	289.51	288.41	288.65	5385574.0
2019-06-14 10:00:00	SPY	ETF	288.64	289.27	288.4615	289.105	6529215.0
2019-06-14 11:00:00	SPY	ETF	289.105	289.24	288.41	288.91	5299475.0
2019-06-14 12:00:00	SPY	ETF	288.9	289.01	288.65	288.947	3992666.0
2019-06-14 13:00:00	SPY	ETF	288.94	289.03	288.72	288.76	3408965.0
2019-06-14 14:00:00	SPY	ETF	288.75	289.21	288.72	289.17	4382947.0
2019-06-14 15:00:00	SPY	ETF	289.17	289.93	289.14	289.19	15087909.0
2019-06-14 16:00:00	SPY	ETF	289.2	289.55	289.1563	289.54	6098175.0
2019-06-14 17:00:00	SPY	ETF	289.55	289.55	289.26	289.3	405422.0
2019-06-14 18:00:00	SPY	ETF	289.33	289.33	289.31	289.33	1346.0
2019-06-14 19:00:00	SPY	ETF	289.33	289.37	289.27	289.33	7769.0
2019-06-14 04:00:00	QQQ	ETF	182.68	182.75	182.3	182.34	23399.0
2019-06-14 05:00:00	QQQ	ETF	182.35	182.44	182.07	182.23	24155.0
2019-06-14 06:00:00	QQQ	ETF	182.23	182.27	181.82	182.03	39365.0
2019-06-14 07:00:00	QQQ	ETF	182.08	182.47	182.0	182.45	108111.0
2019-06-14 08:00:00	QQQ	ETF	182.1	183.2	182.05	182.4201	332006.0
2019-06-14 09:00:00	QQQ	ETF	182.44	182.6	181.94	182.17	3306470.0
2019-06-14 10:00:00	QQQ	ETF	182.17	182.87	182.02	182.6	3230918.0
2019-06-14 11:00:00	QQQ	ETF	182.61	182.765	181.985	182.4185	2312818.0
2019-06-14 12:00:00	QQQ	ETF	182.43	182.61	182.28	182.56	1152308.0
2019-06-14 13:00:00	QQQ	ETF	182.56	182.59	182.38	182.38	1162460.0
2019-06-14 14:00:00	QQQ	ETF	182.385	182.71	182.3537	182.67	1362459.0
2019-06-14 15:00:00	QQQ	ETF	182.67	183.11	182.55	182.58	3986541.0
2019-06-14 16:00:00	QQQ	ETF	182.59	182.67	182.44	182.63	1370915.0
2019-06-14 17:00:00	QQQ	ETF	182.69	182.69	182.5714	182.6	379827.0
2019-06-14 18:00:00	QQQ	ETF	182.52	182.53	182.51	182.52	3884.0
2019-06-14 19:00:00	QQQ	ETF	182.57	182.64	182.53	182.53	5569.0
2019-06-14 05:00:00	IWM	ETF	152.81	152.82	152.8	152.82	10000.0
2019-06-14 06:00:00	IWM	ETF	152.56	152.7	152.56	152.7	6300.0
2019-06-14 07:00:00	IWM	ETF	152.76	152.86	152.7	152.86	15225.0
2019-06-14 08:00:00	IWM	ETF	152.69	152.94	152.69	152.94	199355.0
2019-06-14 09:00:00	IWM	ETF	152.92	153.11	152.09	152.23	1712597.0
2019-06-14 10:00:00	IWM	ETF	152.22	152.59	152.01	152.35	2045765.0
2019-06-14 11:00:00	IWM	ETF	152.35	152.48	151.875	152.23	1508374.0
2019-06-14 12:00:00	IWM	ETF	152.22	152.22	151.85	151.99	767128.0
2019-06-14 13:00:00	IWM	ETF	151.99	152.03	151.74	151.85	575006.0
2019-06-14 14:00:00	IWM	ETF	151.84	152.16	151.81	151.97	1135355.0
2019-06-14 15:00:00	IWM	ETF	151.97	152.34	151.72	151.77	2918997.0
2019-06-14 16:00:00	IWM	ETF	151.73	152.02	151.72	152.0	999969.0
2019-06-14 17:00:00	IWM	ETF	151.73	151.99	151.73	151.75	1823114.0
2019-06-14 19:00:00	IWM	ETF	151.73	151.81	151.73	151.75	1300.0
2019-06-14 04:00:00	DIA	ETF	261.24	261.24	261.13	261.13	3800.0
2019-06-14 05:00:00	DIA	ETF	261.25	261.25	261.07	261.07	1100.0
2019-06-14 06:00:00	DIA	ETF	260.83	261.0	260.83	261.0	300.0
2019-06-14 07:00:00	DIA	ETF	261.06	261.19	260.92	261.19	3900.0

> showing 50 of 10,420 rows — these rows as CSV

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