PREVIEW / etf_1hour / 2018-03-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-22.parquet
  size:    312 KB
  rows:    10,321

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-22 04:00:00	SPY	ETF	268.99	269.68	268.84	269.63	18010.0
2018-03-22 05:00:00	SPY	ETF	269.55	269.56	268.58	268.83	115202.0
2018-03-22 06:00:00	SPY	ETF	268.91	269.24	268.56	268.9	109701.0
2018-03-22 07:00:00	SPY	ETF	268.95	269.25	268.72	268.76	584141.0
2018-03-22 08:00:00	SPY	ETF	268.95	270.64	267.7	268.05	1063959.0
2018-03-22 09:00:00	SPY	ETF	268.05	268.39	267.16	267.68	10139063.0
2018-03-22 10:00:00	SPY	ETF	267.68	268.87	266.33	266.73	15148259.0
2018-03-22 11:00:00	SPY	ETF	266.72	267.08	265.4	265.8	16455067.0
2018-03-22 12:00:00	SPY	ETF	265.8	267.79	265.48	266.915	18804479.0
2018-03-22 13:00:00	SPY	ETF	266.91	268.23	266.2	267.82	12548140.0
2018-03-22 14:00:00	SPY	ETF	267.8	267.9699	265.72	265.8699	13581948.0
2018-03-22 15:00:00	SPY	ETF	265.865	266.47	263.36	263.67	38666630.0
2018-03-22 16:00:00	SPY	ETF	263.7	270.4428	263.32	263.8	16257518.0
2018-03-22 17:00:00	SPY	ETF	263.74	264.1	263.52	263.67	1485140.0
2018-03-22 18:00:00	SPY	ETF	263.69	263.8	262.59	263.02	504579.0
2018-03-22 19:00:00	SPY	ETF	263.04	263.08	261.89	262.0	378070.0
2018-03-22 04:00:00	QQQ	ETF	165.67	166.27	165.58	166.0	72563.0
2018-03-22 05:00:00	QQQ	ETF	166.0	166.0	165.14	165.33	136653.0
2018-03-22 06:00:00	QQQ	ETF	165.33	165.57	164.93	165.21	93910.0
2018-03-22 07:00:00	QQQ	ETF	165.22	165.61	165.22	165.27	239404.0
2018-03-22 08:00:00	QQQ	ETF	165.27	165.63	164.68	164.93	521543.0
2018-03-22 09:00:00	QQQ	ETF	164.94	165.48	164.36	165.04	6216300.0
2018-03-22 10:00:00	QQQ	ETF	165.02	165.77	163.85	164.165	6345452.0
2018-03-22 11:00:00	QQQ	ETF	164.1607	164.48	163.13	163.55	6406352.0
2018-03-22 12:00:00	QQQ	ETF	163.55	164.8266	163.29	164.4	8438184.0
2018-03-22 13:00:00	QQQ	ETF	164.38	165.3701	163.86	165.08	5009947.0
2018-03-22 14:00:00	QQQ	ETF	165.07	165.1692	163.94	164.06	4512943.0
2018-03-22 15:00:00	QQQ	ETF	164.06	164.44	162.59	162.67	11087739.0
2018-03-22 16:00:00	QQQ	ETF	162.69	164.878	162.43	162.6	3733484.0
2018-03-22 17:00:00	QQQ	ETF	162.66	162.84	162.52	162.68	70437.0
2018-03-22 18:00:00	QQQ	ETF	162.64	162.64	161.75	162.07	150786.0
2018-03-22 19:00:00	QQQ	ETF	162.07	162.07	161.2	161.2	201683.0
2018-03-22 04:00:00	IWM	ETF	155.91	156.28	155.78	156.23	6020.0
2018-03-22 05:00:00	IWM	ETF	156.14	156.14	155.6	155.73	18401.0
2018-03-22 06:00:00	IWM	ETF	156.02	156.11	155.67	155.78	35176.0
2018-03-22 07:00:00	IWM	ETF	155.81	156.07	155.78	155.78	52197.0
2018-03-22 08:00:00	IWM	ETF	155.78	156.0	155.3	155.62	163600.0
2018-03-22 09:00:00	IWM	ETF	155.67	156.27	155.29	155.925	2443756.0
2018-03-22 10:00:00	IWM	ETF	155.91	156.62	155.06	155.275	2835554.0
2018-03-22 11:00:00	IWM	ETF	155.26	155.49	154.43	154.81	2434067.0
2018-03-22 12:00:00	IWM	ETF	154.8	156.01	154.705	155.665	3422096.0
2018-03-22 13:00:00	IWM	ETF	155.65	156.55	155.2	156.01	2323098.0
2018-03-22 14:00:00	IWM	ETF	156.02	156.06	154.83	154.91	2335008.0
2018-03-22 15:00:00	IWM	ETF	154.9	155.17	153.31	153.36	7618323.0
2018-03-22 16:00:00	IWM	ETF	153.38	154.5899	152.76	153.27	1939019.0
2018-03-22 17:00:00	IWM	ETF	153.3	153.35	153.16	153.3	5066.0
2018-03-22 18:00:00	IWM	ETF	153.4	153.4	152.56	152.91	35942.0
2018-03-22 19:00:00	IWM	ETF	152.73	152.77	152.3	152.37	28667.0
2018-03-22 04:00:00	DIA	ETF	245.37	246.2	245.37	246.07	1198.0
2018-03-22 05:00:00	DIA	ETF	245.5	245.5	245.5	245.5	100.0

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

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