PREVIEW / etf_1hour / 2018-11-01

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-01.parquet
  size:    325 KB
  rows:    10,648

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-11-01 04:00:00	SPY	ETF	270.6	271.56	270.6	271.46	38640.0
2018-11-01 05:00:00	SPY	ETF	271.5	271.8	271.3	271.8	45176.0
2018-11-01 06:00:00	SPY	ETF	271.87	272.26	271.68	272.0	122606.0
2018-11-01 07:00:00	SPY	ETF	272.0	272.2	271.78	271.82	225087.0
2018-11-01 08:00:00	SPY	ETF	270.63	272.1	270.4	271.24	589065.0
2018-11-01 09:00:00	SPY	ETF	271.24	272.18	270.78	271.29	12974821.0
2018-11-01 10:00:00	SPY	ETF	271.27	272.81	270.38	272.62	19331364.0
2018-11-01 11:00:00	SPY	ETF	272.62	273.07	272.04	272.52	11028609.0
2018-11-01 12:00:00	SPY	ETF	272.525	273.09	272.15	273.04	8667047.0
2018-11-01 13:00:00	SPY	ETF	273.03	273.26	272.5001	272.82	8381705.0
2018-11-01 14:00:00	SPY	ETF	272.82	273.21	272.43	273.13	10028634.0
2018-11-01 15:00:00	SPY	ETF	273.13	273.73	272.7675	273.51	18667231.0
2018-11-01 16:00:00	SPY	ETF	273.45	273.5845	272.18	272.9	6832925.0
2018-11-01 17:00:00	SPY	ETF	272.9	273.51	271.6899	272.01	989174.0
2018-11-01 18:00:00	SPY	ETF	272.05	272.53	271.94	272.53	436886.0
2018-11-01 19:00:00	SPY	ETF	272.5	272.9	272.45	272.9	85712.0
2018-11-01 04:00:00	QQQ	ETF	169.42	170.16	169.4	170.05	7711.0
2018-11-01 05:00:00	QQQ	ETF	170.07	170.33	169.99	170.33	26989.0
2018-11-01 06:00:00	QQQ	ETF	170.37	170.7	170.25	170.55	36856.0
2018-11-01 07:00:00	QQQ	ETF	170.47	170.66	170.27	170.31	178302.0
2018-11-01 08:00:00	QQQ	ETF	170.46	170.64	169.52	169.79	403174.0
2018-11-01 09:00:00	QQQ	ETF	169.79	170.655	168.98	169.56	8040852.0
2018-11-01 10:00:00	QQQ	ETF	169.53	170.87	168.78	170.63	9564388.0
2018-11-01 11:00:00	QQQ	ETF	170.64	171.43	170.2494	171.01	5377987.0
2018-11-01 12:00:00	QQQ	ETF	171.01	171.6	170.7	171.57	3268931.0
2018-11-01 13:00:00	QQQ	ETF	171.55	172.08	171.27	171.72	4371303.0
2018-11-01 14:00:00	QQQ	ETF	171.72	171.9904	171.38	171.86	3142717.0
2018-11-01 15:00:00	QQQ	ETF	171.86	172.24	171.54	172.12	6452514.0
2018-11-01 16:00:00	QQQ	ETF	172.13	172.45	170.34	170.99	2642452.0
2018-11-01 17:00:00	QQQ	ETF	170.81	172.06	169.44	169.85	519432.0
2018-11-01 18:00:00	QQQ	ETF	169.9	170.3	169.71	170.3	431627.0
2018-11-01 19:00:00	QQQ	ETF	170.29	170.67	170.26	170.67	93946.0
2018-11-01 04:00:00	IWM	ETF	150.41	150.88	150.41	150.88	2083.0
2018-11-01 05:00:00	IWM	ETF	151.0	151.0	150.83	150.9	2600.0
2018-11-01 06:00:00	IWM	ETF	151.12	151.21	150.89	151.01	17475.0
2018-11-01 07:00:00	IWM	ETF	151.02	151.17	150.98	151.07	20690.0
2018-11-01 08:00:00	IWM	ETF	151.02	151.1	150.5	150.67	70118.0
2018-11-01 09:00:00	IWM	ETF	150.62	151.78	150.62	151.47	2775838.0
2018-11-01 10:00:00	IWM	ETF	151.41	152.27	150.89	152.27	4415711.0
2018-11-01 11:00:00	IWM	ETF	152.2727	152.53	151.81	152.3	3433422.0
2018-11-01 12:00:00	IWM	ETF	152.3	153.13	151.97	153.12	1820670.0
2018-11-01 13:00:00	IWM	ETF	153.11	153.52	152.94	153.38	2302012.0
2018-11-01 14:00:00	IWM	ETF	153.39	153.7725	153.16	153.705	2760087.0
2018-11-01 15:00:00	IWM	ETF	153.7075	153.71	153.24	153.45	5012261.0
2018-11-01 16:00:00	IWM	ETF	153.42	153.49	152.74	153.03	1521865.0
2018-11-01 17:00:00	IWM	ETF	153.29	153.29	152.48	152.52	26543.0
2018-11-01 18:00:00	IWM	ETF	152.75	153.49	152.71	152.85	12390.0
2018-11-01 19:00:00	IWM	ETF	152.87	153.08	152.87	153.08	5496.0
2018-11-01 05:00:00	DIA	ETF	251.94	251.94	251.94	251.94	100.0
2018-11-01 06:00:00	DIA	ETF	252.2	252.5	252.2	252.48	2700.0

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

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