PREVIEW / etf_1hour / 2018-01-31

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-31.parquet
  size:    314 KB
  rows:    10,348

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-01-31 04:00:00	SPY	ETF	282.85	283.0	282.46	282.56	19070.0
2018-01-31 05:00:00	SPY	ETF	282.59	282.62	282.27	282.56	14301.0
2018-01-31 06:00:00	SPY	ETF	282.5	282.78	282.4	282.65	37010.0
2018-01-31 07:00:00	SPY	ETF	282.65	283.25	282.62	283.25	461928.0
2018-01-31 08:00:00	SPY	ETF	283.25	283.25	281.76	282.78	804320.0
2018-01-31 09:00:00	SPY	ETF	282.78	283.3	282.51	282.8	7802561.0
2018-01-31 10:00:00	SPY	ETF	282.79	283.06	282.01	282.28	11066211.0
2018-01-31 11:00:00	SPY	ETF	282.28	282.32	281.87	281.9	7263053.0
2018-01-31 12:00:00	SPY	ETF	281.89	282.36	281.82	282.25	7345270.0
2018-01-31 13:00:00	SPY	ETF	282.26	282.58	282.2	282.25	5729745.0
2018-01-31 14:00:00	SPY	ETF	282.26	282.79	280.69	281.27	16733700.0
2018-01-31 15:00:00	SPY	ETF	281.27	282.52	280.68	281.91	37163529.0
2018-01-31 16:00:00	SPY	ETF	281.9	282.3	281.7037	281.98	18949491.0
2018-01-31 17:00:00	SPY	ETF	281.96	282.4	281.9	282.35	712820.0
2018-01-31 18:00:00	SPY	ETF	282.3	282.8	281.9	282.5	120569.0
2018-01-31 19:00:00	SPY	ETF	282.54	282.72	282.45	282.54	81631.0
2018-01-31 20:00:00	SPY	ETF	281.7803	281.9	281.7803	281.9	85172.0
2018-01-31 04:00:00	QQQ	ETF	169.26	169.33	169.08	169.19	38509.0
2018-01-31 05:00:00	QQQ	ETF	169.16	169.18	169.03	169.18	12504.0
2018-01-31 06:00:00	QQQ	ETF	169.21	169.37	169.08	169.27	35505.0
2018-01-31 07:00:00	QQQ	ETF	169.25	169.59	169.22	169.58	137076.0
2018-01-31 08:00:00	QQQ	ETF	168.96	169.7	168.96	169.62	434452.0
2018-01-31 09:00:00	QQQ	ETF	169.61	169.9899	168.7	169.73	3117178.0
2018-01-31 10:00:00	QQQ	ETF	169.71	169.9	169.3	169.44	4512150.0
2018-01-31 11:00:00	QQQ	ETF	169.445	169.495	168.94	168.96	3563123.0
2018-01-31 12:00:00	QQQ	ETF	168.97	169.465	168.8862	169.37	2784969.0
2018-01-31 13:00:00	QQQ	ETF	169.36	169.64	169.32	169.38	3025324.0
2018-01-31 14:00:00	QQQ	ETF	169.38	169.73	168.56	168.84	5345040.0
2018-01-31 15:00:00	QQQ	ETF	168.84	169.51	168.34	169.32	7867130.0
2018-01-31 16:00:00	QQQ	ETF	169.32	169.42	168.3	168.45	3099476.0
2018-01-31 17:00:00	QQQ	ETF	168.53	169.79	168.5	169.55	590300.0
2018-01-31 18:00:00	QQQ	ETF	169.69	169.79	169.34	169.43	1179890.0
2018-01-31 19:00:00	QQQ	ETF	169.45	169.74	169.45	169.52	17668.0
2018-01-31 04:00:00	IWM	ETF	158.0	158.06	157.91	157.91	5500.0
2018-01-31 05:00:00	IWM	ETF	157.7	157.95	157.68	157.92	10373.0
2018-01-31 06:00:00	IWM	ETF	158.01	158.03	157.66	157.75	6947.0
2018-01-31 07:00:00	IWM	ETF	157.88	158.32	157.88	158.32	65044.0
2018-01-31 08:00:00	IWM	ETF	157.92	158.3	157.69	157.83	125910.0
2018-01-31 09:00:00	IWM	ETF	157.82	158.42	157.68	157.74	2403987.0
2018-01-31 10:00:00	IWM	ETF	157.73	157.83	157.02	157.19	2802333.0
2018-01-31 11:00:00	IWM	ETF	157.22	157.24	156.81	156.83	1666349.0
2018-01-31 12:00:00	IWM	ETF	156.83	157.05	156.77	156.94	1161613.0
2018-01-31 13:00:00	IWM	ETF	156.93	157.18	156.84	156.96	1374514.0
2018-01-31 14:00:00	IWM	ETF	156.92	157.26	155.9199	156.34	4239912.0
2018-01-31 15:00:00	IWM	ETF	156.34	156.83	156.02	156.37	6118212.0
2018-01-31 16:00:00	IWM	ETF	156.37	156.72	156.29	156.48	3906930.0
2018-01-31 17:00:00	IWM	ETF	156.36	156.62	156.36	156.36	519207.0
2018-01-31 18:00:00	IWM	ETF	156.66	156.87	156.66	156.72	28453.0
2018-01-31 19:00:00	IWM	ETF	156.85	156.94	156.75	156.79	10323.0
2018-01-31 04:00:00	DIA	ETF	261.2	261.2	261.2	261.2	100.0

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

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