PREVIEW / etf_1hour / 2018-03-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-23.parquet
  size:    309 KB
  rows:    10,220

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-03-23 04:00:00	SPY	ETF	263.39	263.86	262.43	262.56	43905.0
2018-03-23 05:00:00	SPY	ETF	262.5	262.71	261.66	261.86	58035.0
2018-03-23 06:00:00	SPY	ETF	261.84	262.9	261.63	262.85	98906.0
2018-03-23 07:00:00	SPY	ETF	262.88	263.56	262.64	263.52	471147.0
2018-03-23 08:00:00	SPY	ETF	263.5	264.34	261.72	263.4	2302914.0
2018-03-23 09:00:00	SPY	ETF	263.43	265.02	263.25	263.955	11094284.0
2018-03-23 10:00:00	SPY	ETF	263.9401	264.6	263.35	264.51	20395348.0
2018-03-23 11:00:00	SPY	ETF	264.49	264.74	261.76	261.84	13692949.0
2018-03-23 12:00:00	SPY	ETF	261.83	263.12	261.77	262.06	14800357.0
2018-03-23 13:00:00	SPY	ETF	262.07	264.1	261.81	263.82	12590117.0
2018-03-23 14:00:00	SPY	ETF	263.83	264.14	260.08	260.21	20030756.0
2018-03-23 15:00:00	SPY	ETF	260.21	260.8	257.83	258.01	57592788.0
2018-03-23 16:00:00	SPY	ETF	258.0	259.54	257.97	258.85	24835905.0
2018-03-23 17:00:00	SPY	ETF	258.95	258.95	258.05	258.24	2422714.0
2018-03-23 18:00:00	SPY	ETF	258.24	258.66	258.13	258.5	93456.0
2018-03-23 19:00:00	SPY	ETF	258.49	258.8	258.4	258.65	103864.0
2018-03-23 04:00:00	QQQ	ETF	161.97	162.18	161.16	161.3	30254.0
2018-03-23 05:00:00	QQQ	ETF	161.31	161.42	160.7	160.88	48690.0
2018-03-23 06:00:00	QQQ	ETF	160.86	161.48	160.71	161.43	105018.0
2018-03-23 07:00:00	QQQ	ETF	161.43	162.08	161.39	162.08	237956.0
2018-03-23 08:00:00	QQQ	ETF	162.05	162.88	161.44	162.24	863105.0
2018-03-23 09:00:00	QQQ	ETF	162.2	163.3	161.61	162.43	6512600.0
2018-03-23 10:00:00	QQQ	ETF	162.44	163.13	161.89	163.089	7336881.0
2018-03-23 11:00:00	QQQ	ETF	163.07	163.22	160.92	160.97	6039310.0
2018-03-23 12:00:00	QQQ	ETF	160.97	161.83	160.94	161.07	4699652.0
2018-03-23 13:00:00	QQQ	ETF	161.06	162.68	160.81	162.51	6429505.0
2018-03-23 14:00:00	QQQ	ETF	162.495	162.695	159.96	160.06	7912506.0
2018-03-23 15:00:00	QQQ	ETF	160.04	160.55	158.44	158.44	20901914.0
2018-03-23 16:00:00	QQQ	ETF	158.43	159.36	158.41	159.13	5675011.0
2018-03-23 17:00:00	QQQ	ETF	159.02	159.1	158.51	158.85	1321728.0
2018-03-23 18:00:00	QQQ	ETF	158.87	158.99	158.78	158.85	18770.0
2018-03-23 19:00:00	QQQ	ETF	158.85	158.99	158.75	158.82	9317.0
2018-03-23 04:00:00	IWM	ETF	152.9	152.95	152.36	152.37	14906.0
2018-03-23 05:00:00	IWM	ETF	152.4	152.52	152.09	152.18	9120.0
2018-03-23 06:00:00	IWM	ETF	152.05	152.76	152.05	152.58	12735.0
2018-03-23 07:00:00	IWM	ETF	152.69	153.22	152.66	153.21	289592.0
2018-03-23 08:00:00	IWM	ETF	152.93	153.51	152.86	153.11	344689.0
2018-03-23 09:00:00	IWM	ETF	153.11	154.13	152.69	152.88	3974255.0
2018-03-23 10:00:00	IWM	ETF	152.88	153.44	152.62	153.4	2884139.0
2018-03-23 11:00:00	IWM	ETF	153.39	153.52	151.75	151.795	2918679.0
2018-03-23 12:00:00	IWM	ETF	151.8	152.62	151.785	152.16	2081371.0
2018-03-23 13:00:00	IWM	ETF	152.15	153.12	152.035	152.89	1926974.0
2018-03-23 14:00:00	IWM	ETF	152.89	153.07	151.09	151.16	2794285.0
2018-03-23 15:00:00	IWM	ETF	151.15	151.6	150.0	150.04	9585291.0
2018-03-23 16:00:00	IWM	ETF	150.04	150.78	149.9307	150.71	3371775.0
2018-03-23 17:00:00	IWM	ETF	150.51	150.65	150.38	150.48	15531.0
2018-03-23 18:00:00	IWM	ETF	150.49	150.49	150.4	150.4	1467.0
2018-03-23 19:00:00	IWM	ETF	150.32	150.55	150.16	150.48	20548.0
2018-03-23 04:00:00	DIA	ETF	238.98	239.1	238.4	238.4	3256.0
2018-03-23 05:00:00	DIA	ETF	238.0	238.0	237.54	237.54	2500.0

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

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