PREVIEW / etf_1hour / 2018-03-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-01.parquet
  size:    315 KB
  rows:    10,342

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-01 04:00:00	SPY	ETF	272.0	272.0	270.72	270.83	101738.0
2018-03-01 05:00:00	SPY	ETF	270.95	271.17	270.54	271.13	48751.0
2018-03-01 06:00:00	SPY	ETF	271.07	271.33	269.94	270.38	131911.0
2018-03-01 07:00:00	SPY	ETF	270.36	270.94	270.24	270.59	518445.0
2018-03-01 08:00:00	SPY	ETF	270.66	272.16	270.31	271.7	1464993.0
2018-03-01 09:00:00	SPY	ETF	271.72	272.09	270.02	270.24	14116534.0
2018-03-01 10:00:00	SPY	ETF	270.22	273.17	269.95	271.13	20097783.0
2018-03-01 11:00:00	SPY	ETF	271.12	272.245	270.72	271.8	10380132.0
2018-03-01 12:00:00	SPY	ETF	271.8	271.87	269.68	269.95	15825131.0
2018-03-01 13:00:00	SPY	ETF	269.94	269.94	267.28	267.2938	23007187.0
2018-03-01 14:00:00	SPY	ETF	267.3	267.58	266.0	267.16	30618195.0
2018-03-01 15:00:00	SPY	ETF	267.16	268.99	266.49	267.73	41965864.0
2018-03-01 16:00:00	SPY	ETF	267.73	268.45	267.63	268.11	16028330.0
2018-03-01 17:00:00	SPY	ETF	268.15	271.2841	267.7	267.91	205296.0
2018-03-01 18:00:00	SPY	ETF	267.95	268.29	267.7	268.19	264809.0
2018-03-01 19:00:00	SPY	ETF	268.19	268.53	268.18	268.5	80458.0
2018-03-01 04:00:00	QQQ	ETF	167.13	169.19	166.99	167.04	43125.0
2018-03-01 05:00:00	QQQ	ETF	167.05	167.25	166.84	167.16	28079.0
2018-03-01 06:00:00	QQQ	ETF	167.22	167.22	166.27	166.57	50389.0
2018-03-01 07:00:00	QQQ	ETF	166.6	167.0	166.5	166.82	253389.0
2018-03-01 08:00:00	QQQ	ETF	166.57	167.67	166.57	167.62	282679.0
2018-03-01 09:00:00	QQQ	ETF	167.61	167.86	165.72	165.88	7635346.0
2018-03-01 10:00:00	QQQ	ETF	165.89	168.07	165.61	166.58	11649322.0
2018-03-01 11:00:00	QQQ	ETF	166.57	167.5	166.46	167.22	4678860.0
2018-03-01 12:00:00	QQQ	ETF	167.24	167.28	165.7533	165.88	4910623.0
2018-03-01 13:00:00	QQQ	ETF	165.85	165.85	163.8	163.81	8868178.0
2018-03-01 14:00:00	QQQ	ETF	163.82	164.5	163.001	164.28	10646953.0
2018-03-01 15:00:00	QQQ	ETF	164.27	165.41	163.72	164.54	11814391.0
2018-03-01 16:00:00	QQQ	ETF	164.55	166.7121	163.8657	164.89	8374547.0
2018-03-01 17:00:00	QQQ	ETF	164.89	165.0355	164.48	164.9	375181.0
2018-03-01 18:00:00	QQQ	ETF	164.9	165.07	164.7	164.92	199495.0
2018-03-01 19:00:00	QQQ	ETF	164.99	165.15	164.98	165.14	36489.0
2018-03-01 04:00:00	IWM	ETF	150.21	150.21	149.57	149.61	7985.0
2018-03-01 05:00:00	IWM	ETF	149.5	149.81	149.5	149.77	6216.0
2018-03-01 06:00:00	IWM	ETF	149.77	149.9	149.22	149.45	34410.0
2018-03-01 07:00:00	IWM	ETF	149.48	149.85	149.47	149.65	177493.0
2018-03-01 08:00:00	IWM	ETF	149.61	150.45	149.61	150.31	312482.0
2018-03-01 09:00:00	IWM	ETF	150.37	150.59	149.15	149.33	3404482.0
2018-03-01 10:00:00	IWM	ETF	149.34	151.28	149.27	150.18	6322060.0
2018-03-01 11:00:00	IWM	ETF	150.18	151.57	150.03	151.4014	2957787.0
2018-03-01 12:00:00	IWM	ETF	151.42	151.51	150.26	150.37	2936690.0
2018-03-01 13:00:00	IWM	ETF	150.36	150.36	149.11	149.12	4054175.0
2018-03-01 14:00:00	IWM	ETF	149.1166	149.75	148.38	149.68	4978286.0
2018-03-01 15:00:00	IWM	ETF	149.65	150.63	149.32	149.95	7531506.0
2018-03-01 16:00:00	IWM	ETF	149.93	150.01	149.6	149.81	1436598.0
2018-03-01 17:00:00	IWM	ETF	149.95	150.6886	149.95	150.6886	37143.0
2018-03-01 18:00:00	IWM	ETF	149.9	149.9	149.71	149.88	10278.0
2018-03-01 19:00:00	IWM	ETF	150.01	150.1	150.0	150.08	4873.0
2018-03-01 04:00:00	DIA	ETF	250.57	250.57	250.1	250.1	950.0
2018-03-01 05:00:00	DIA	ETF	249.5	249.5	249.49	249.49	300.0

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

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