PREVIEW / etf_1hour / 2018-02-20

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-20.parquet
  size:    310 KB
  rows:    10,230

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
2018-02-20 04:00:00	SPY	ETF	272.54	272.58	271.18	271.23	46705.0
2018-02-20 05:00:00	SPY	ETF	271.26	271.7	270.86	271.7	36089.0
2018-02-20 06:00:00	SPY	ETF	271.66	271.66	271.1	271.51	57804.0
2018-02-20 07:00:00	SPY	ETF	271.58	271.92	271.51	271.86	219315.0
2018-02-20 08:00:00	SPY	ETF	271.86	272.81	271.32	271.75	527830.0
2018-02-20 09:00:00	SPY	ETF	271.76	273.1075	271.3	272.24	7856740.0
2018-02-20 10:00:00	SPY	ETF	272.25	272.76	271.68	271.9	10449404.0
2018-02-20 11:00:00	SPY	ETF	271.89	273.54	271.8	273.475	14257879.0
2018-02-20 12:00:00	SPY	ETF	273.48	273.67	273.13	273.405	3546364.0
2018-02-20 13:00:00	SPY	ETF	273.4	273.4638	272.4107	273.02	5171791.0
2018-02-20 14:00:00	SPY	ETF	273.0182	273.1	271.67	271.74	6606231.0
2018-02-20 15:00:00	SPY	ETF	271.74	272.04	270.5	271.43	21841597.0
2018-02-20 16:00:00	SPY	ETF	271.44	271.57	271.13	271.4357	8497019.0
2018-02-20 17:00:00	SPY	ETF	271.47	271.63	271.38	271.38	1797537.0
2018-02-20 18:00:00	SPY	ETF	271.42	271.83	271.18	271.8	801693.0
2018-02-20 19:00:00	SPY	ETF	271.76	272.02	271.63	271.98	97966.0
2018-02-20 04:00:00	QQQ	ETF	164.96	164.96	163.99	164.08	29688.0
2018-02-20 05:00:00	QQQ	ETF	164.04	164.16	163.79	164.13	39541.0
2018-02-20 06:00:00	QQQ	ETF	164.07	164.11	163.88	164.02	78446.0
2018-02-20 07:00:00	QQQ	ETF	164.14	164.33	164.08	164.28	91429.0
2018-02-20 08:00:00	QQQ	ETF	164.11	164.99	164.08	164.33	308774.0
2018-02-20 09:00:00	QQQ	ETF	164.36	165.59	164.22	165.18	4064988.0
2018-02-20 10:00:00	QQQ	ETF	165.18	165.905	165.0955	165.47	4014471.0
2018-02-20 11:00:00	QQQ	ETF	165.4599	166.58	165.4	166.54	3138125.0
2018-02-20 12:00:00	QQQ	ETF	166.54	166.68	166.36	166.6	2058580.0
2018-02-20 13:00:00	QQQ	ETF	166.59	166.66	166.02	166.56	2859787.0
2018-02-20 14:00:00	QQQ	ETF	166.57	166.61	165.2948	165.384	3209135.0
2018-02-20 15:00:00	QQQ	ETF	165.39	165.57	164.44	165.24	7745329.0
2018-02-20 16:00:00	QQQ	ETF	165.23	165.56	165.13	165.47	4215391.0
2018-02-20 17:00:00	QQQ	ETF	165.42	165.54	165.29	165.42	87585.0
2018-02-20 18:00:00	QQQ	ETF	165.4	165.69	165.24	165.68	34204.0
2018-02-20 19:00:00	QQQ	ETF	165.65	165.83	165.62	165.76	63505.0
2018-02-20 04:00:00	IWM	ETF	152.51	152.51	152.0	152.03	3040.0
2018-02-20 05:00:00	IWM	ETF	152.05	152.21	151.83	152.21	2563.0
2018-02-20 06:00:00	IWM	ETF	152.15	152.15	151.97	152.11	23180.0
2018-02-20 07:00:00	IWM	ETF	152.24	152.48	152.23	152.48	30009.0
2018-02-20 08:00:00	IWM	ETF	152.35	152.53	152.26	152.27	80632.0
2018-02-20 09:00:00	IWM	ETF	152.26	153.77	152.11	153.3	2165320.0
2018-02-20 10:00:00	IWM	ETF	153.3	153.57	152.61	152.74	2488014.0
2018-02-20 11:00:00	IWM	ETF	152.74	153.72	152.67	153.66	1734043.0
2018-02-20 12:00:00	IWM	ETF	153.66	153.74	153.235	153.34	1012745.0
2018-02-20 13:00:00	IWM	ETF	153.33	153.4	152.71	153.13	1254761.0
2018-02-20 14:00:00	IWM	ETF	153.13	153.23	152.32	152.38	1743592.0
2018-02-20 15:00:00	IWM	ETF	152.39	153.0	151.67	152.05	4279639.0
2018-02-20 16:00:00	IWM	ETF	152.08	152.25	151.86	152.22	6613899.0
2018-02-20 17:00:00	IWM	ETF	152.13	152.89	152.08	152.3	245238.0
2018-02-20 18:00:00	IWM	ETF	152.21	152.49	152.1	152.49	23824.0
2018-02-20 19:00:00	IWM	ETF	152.49	152.64	152.38	152.6	15320.0
2018-02-20 20:00:00	IWM	ETF	152.08	152.55	152.08	152.55	2000.0
2018-02-20 04:00:00	DIA	ETF	252.02	252.02	250.5	250.5	1280.0

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

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