PREVIEW / etf_1hour / 2018-03-28

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-28.parquet
  size:    300 KB
  rows:    9,929

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-28 04:00:00	SPY	ETF	259.61	260.53	259.32	259.81	151035.0
2018-03-28 05:00:00	SPY	ETF	259.82	260.36	259.49	260.07	27738.0
2018-03-28 06:00:00	SPY	ETF	260.22	261.05	260.07	260.97	122481.0
2018-03-28 07:00:00	SPY	ETF	261.03	261.71	260.97	261.23	441008.0
2018-03-28 08:00:00	SPY	ETF	261.35	261.87	259.12	260.56	621143.0
2018-03-28 09:00:00	SPY	ETF	260.56	261.56	259.56	261.227	13834226.0
2018-03-28 10:00:00	SPY	ETF	261.22	261.9	258.58	259.76	20293434.0
2018-03-28 11:00:00	SPY	ETF	259.77	261.03	259.0	260.35	17340343.0
2018-03-28 12:00:00	SPY	ETF	260.34	262.64	260.1	260.2465	16672520.0
2018-03-28 13:00:00	SPY	ETF	260.2421	261.76	259.61	261.08	15068462.0
2018-03-28 14:00:00	SPY	ETF	261.07	261.47	260.05	260.34	14135818.0
2018-03-28 15:00:00	SPY	ETF	260.33	261.25	259.01	259.84	28823107.0
2018-03-28 16:00:00	SPY	ETF	259.84	260.4	259.5848	260.17	11082387.0
2018-03-28 17:00:00	SPY	ETF	260.27	260.29	259.97	260.28	219717.0
2018-03-28 18:00:00	SPY	ETF	260.3	260.8	259.83	260.57	86148.0
2018-03-28 19:00:00	SPY	ETF	260.51	260.84	260.31	260.53	53748.0
2018-03-28 04:00:00	QQQ	ETF	157.99	158.49	157.66	157.95	114350.0
2018-03-28 05:00:00	QQQ	ETF	157.95	158.56	157.64	158.38	58216.0
2018-03-28 06:00:00	QQQ	ETF	158.49	159.15	158.23	159.15	102163.0
2018-03-28 07:00:00	QQQ	ETF	159.14	159.91	159.06	159.59	416861.0
2018-03-28 08:00:00	QQQ	ETF	159.93	159.93	158.18	158.22	1013514.0
2018-03-28 09:00:00	QQQ	ETF	158.2	158.93	156.59	158.6	13570471.0
2018-03-28 10:00:00	QQQ	ETF	158.6	159.39	156.04	157.26	15292196.0
2018-03-28 11:00:00	QQQ	ETF	157.25	158.25	156.32	157.7	9414399.0
2018-03-28 12:00:00	QQQ	ETF	157.69	159.78	157.48	157.66	10584606.0
2018-03-28 13:00:00	QQQ	ETF	157.66	159.08	157.14	158.4	6371758.0
2018-03-28 14:00:00	QQQ	ETF	158.41	158.73	157.4	157.5848	5113743.0
2018-03-28 15:00:00	QQQ	ETF	157.57	158.41	156.64	157.28	11617420.0
2018-03-28 16:00:00	QQQ	ETF	157.28	157.89	157.19	157.69	2955146.0
2018-03-28 17:00:00	QQQ	ETF	157.74	157.75	157.25	157.68	1129669.0
2018-03-28 18:00:00	QQQ	ETF	157.76	158.07	157.65	158.0	106702.0
2018-03-28 19:00:00	QQQ	ETF	157.95	158.05	157.72	157.78	80437.0
2018-03-28 04:00:00	IWM	ETF	149.79	150.08	149.68	149.95	22087.0
2018-03-28 05:00:00	IWM	ETF	149.9	150.13	149.9	150.13	7999.0
2018-03-28 06:00:00	IWM	ETF	150.15	150.61	150.15	150.61	18998.0
2018-03-28 07:00:00	IWM	ETF	150.64	151.13	150.64	150.81	84778.0
2018-03-28 08:00:00	IWM	ETF	151.01	151.44	150.54	150.63	258444.0
2018-03-28 09:00:00	IWM	ETF	150.51	150.895	149.78	150.8586	2912050.0
2018-03-28 10:00:00	IWM	ETF	150.86	151.26	149.39	149.93	4099876.0
2018-03-28 11:00:00	IWM	ETF	149.94	150.6	149.47	150.157	2387157.0
2018-03-28 12:00:00	IWM	ETF	150.17	151.23	150.06	150.1	2299483.0
2018-03-28 13:00:00	IWM	ETF	150.11	151.35	149.94	150.88	2940243.0
2018-03-28 14:00:00	IWM	ETF	150.88	151.33	150.38	150.43	2347585.0
2018-03-28 15:00:00	IWM	ETF	150.42	150.55	149.71	150.33	4201087.0
2018-03-28 16:00:00	IWM	ETF	150.32	150.88	150.27	150.66	1832305.0
2018-03-28 17:00:00	IWM	ETF	150.31	150.68	150.31	150.62	30300.0
2018-03-28 18:00:00	IWM	ETF	150.68	151.0	150.68	151.0	6221.0
2018-03-28 19:00:00	IWM	ETF	150.85	151.0	150.74	150.77	7808.0
2018-03-28 07:00:00	DIA	ETF	239.12	239.42	238.99	239.08	2651.0
2018-03-28 08:00:00	DIA	ETF	239.44	239.74	237.332	238.83	43388.0

> showing 50 of 9,929 rows — these rows as CSV

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