PREVIEW / etf_1hour / 2018-10-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-23.parquet
  size:    332 KB
  rows:    10,827

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-10-23 04:00:00	SPY	ETF	272.11	272.11	271.48	271.66	127437.0
2018-10-23 05:00:00	SPY	ETF	271.65	271.65	270.8	271.63	179313.0
2018-10-23 06:00:00	SPY	ETF	271.64	272.04	271.23	271.76	176110.0
2018-10-23 07:00:00	SPY	ETF	271.71	271.94	270.5	271.32	1219254.0
2018-10-23 08:00:00	SPY	ETF	271.7701	272.9	270.75	271.22	1587836.0
2018-10-23 09:00:00	SPY	ETF	271.23	271.72	270.04	270.66	17964023.0
2018-10-23 10:00:00	SPY	ETF	270.6515	271.6163	268.61	269.95	26440737.0
2018-10-23 11:00:00	SPY	ETF	269.95	271.11	269.48	269.5836	14300474.0
2018-10-23 12:00:00	SPY	ETF	269.58	271.855	269.55	271.31	12040810.0
2018-10-23 13:00:00	SPY	ETF	271.31	273.015	271.22	271.66	14451624.0
2018-10-23 14:00:00	SPY	ETF	271.66	274.58	271.66	274.32	16044190.0
2018-10-23 15:00:00	SPY	ETF	274.315	274.87	273.27	273.54	25076667.0
2018-10-23 16:00:00	SPY	ETF	273.49	274.13	271.74	274.0	13924783.0
2018-10-23 17:00:00	SPY	ETF	273.93	273.96	273.61	273.85	400946.0
2018-10-23 18:00:00	SPY	ETF	273.87	274.07	273.55	273.6	389550.0
2018-10-23 19:00:00	SPY	ETF	273.63	274.11	273.61	273.99	104186.0
2018-10-23 04:00:00	QQQ	ETF	171.69	171.69	171.25	171.35	111509.0
2018-10-23 05:00:00	QQQ	ETF	171.3	171.49	170.77	171.49	68761.0
2018-10-23 06:00:00	QQQ	ETF	171.42	171.63	171.03	171.5	95256.0
2018-10-23 07:00:00	QQQ	ETF	171.47	171.57	170.56	171.02	450126.0
2018-10-23 08:00:00	QQQ	ETF	171.07	172.53	170.5301	171.12	665325.0
2018-10-23 09:00:00	QQQ	ETF	171.03	171.4	170.18	170.47	11572655.0
2018-10-23 10:00:00	QQQ	ETF	170.47	170.58	168.82	169.95	14450782.0
2018-10-23 11:00:00	QQQ	ETF	169.94	171.0	169.49	169.98	8590010.0
2018-10-23 12:00:00	QQQ	ETF	169.98	172.26	169.97	171.525	8798773.0
2018-10-23 13:00:00	QQQ	ETF	171.52	172.56	171.44	171.63	6953441.0
2018-10-23 14:00:00	QQQ	ETF	171.66	173.88	171.58	173.71	7499655.0
2018-10-23 15:00:00	QQQ	ETF	173.71	174.13	173.08	173.4	9284635.0
2018-10-23 16:00:00	QQQ	ETF	173.39	173.6	173.16	173.58	1852237.0
2018-10-23 17:00:00	QQQ	ETF	173.58	173.58	173.27	173.27	223879.0
2018-10-23 18:00:00	QQQ	ETF	173.45	173.52	173.07	173.07	90711.0
2018-10-23 19:00:00	QQQ	ETF	173.15	173.57	173.15	173.47	32058.0
2018-10-23 04:00:00	IWM	ETF	151.99	151.99	151.61	151.64	7267.0
2018-10-23 05:00:00	IWM	ETF	151.48	151.48	151.16	151.45	10738.0
2018-10-23 06:00:00	IWM	ETF	151.44	151.61	151.44	151.58	4047.0
2018-10-23 07:00:00	IWM	ETF	151.66	151.67	151.09	151.51	136247.0
2018-10-23 08:00:00	IWM	ETF	151.6101	151.9	151.19	151.39	103526.0
2018-10-23 09:00:00	IWM	ETF	151.27	151.31	150.6	150.87	5356791.0
2018-10-23 10:00:00	IWM	ETF	150.865	150.98	148.92	149.95	8666849.0
2018-10-23 11:00:00	IWM	ETF	149.95	150.87	149.75	150.0665	4344228.0
2018-10-23 12:00:00	IWM	ETF	150.05	151.65	150.05	151.06	3407817.0
2018-10-23 13:00:00	IWM	ETF	151.05	151.94	151.0	151.2636	2767323.0
2018-10-23 14:00:00	IWM	ETF	151.26	152.78	151.23	152.63	3379739.0
2018-10-23 15:00:00	IWM	ETF	152.62	152.89	151.58	151.7	4624202.0
2018-10-23 16:00:00	IWM	ETF	151.7	152.1	150.2227	151.93	828564.0
2018-10-23 17:00:00	IWM	ETF	151.8	151.94	151.8	151.81	3818.0
2018-10-23 18:00:00	IWM	ETF	151.86	152.04	151.71	151.72	15777.0
2018-10-23 19:00:00	IWM	ETF	151.79	152.08	151.79	152.06	6250.0
2018-10-23 04:00:00	DIA	ETF	250.51	250.51	250.42	250.42	500.0
2018-10-23 05:00:00	DIA	ETF	250.04	250.14	249.49	249.95	2280.0

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

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