PREVIEW / etf_1hour / 2018-04-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-17.parquet
  size:    302 KB
  rows:    9,886

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-04-17 04:00:00	SPY	ETF	268.59	268.86	268.36	268.86	36356.0
2018-04-17 05:00:00	SPY	ETF	268.73	268.87	268.63	268.87	17728.0
2018-04-17 06:00:00	SPY	ETF	268.83	269.17	268.8	269.11	198689.0
2018-04-17 07:00:00	SPY	ETF	269.09	269.09	268.88	269.03	171650.0
2018-04-17 08:00:00	SPY	ETF	269.04	269.37	267.33	269.21	647973.0
2018-04-17 09:00:00	SPY	ETF	269.23	269.44	268.75	269.33	6313792.0
2018-04-17 10:00:00	SPY	ETF	269.34	270.04	269.24	269.98	7902459.0
2018-04-17 11:00:00	SPY	ETF	269.98	270.36	269.91	270.02	8572093.0
2018-04-17 12:00:00	SPY	ETF	270.03	270.33	269.86	270.02	3290870.0
2018-04-17 13:00:00	SPY	ETF	270.02	270.23	269.64	270.15	5456204.0
2018-04-17 14:00:00	SPY	ETF	270.15	270.43	269.68	270.13	5657687.0
2018-04-17 15:00:00	SPY	ETF	270.12	270.87	270.02	270.15	16178709.0
2018-04-17 16:00:00	SPY	ETF	270.14	270.28	270.06	270.07	7034947.0
2018-04-17 17:00:00	SPY	ETF	270.04	270.19	269.83	269.9	979937.0
2018-04-17 18:00:00	SPY	ETF	269.91	270.2	269.91	270.18	102045.0
2018-04-17 19:00:00	SPY	ETF	270.2	270.33	270.15	270.25	33844.0
2018-04-17 04:00:00	QQQ	ETF	163.62	163.94	163.6	163.94	51986.0
2018-04-17 05:00:00	QQQ	ETF	163.83	164.0	163.74	164.0	20980.0
2018-04-17 06:00:00	QQQ	ETF	164.04	164.11	164.01	164.05	12091.0
2018-04-17 07:00:00	QQQ	ETF	164.0	164.13	163.9	164.13	62927.0
2018-04-17 08:00:00	QQQ	ETF	163.96	164.42	163.93	164.25	332877.0
2018-04-17 09:00:00	QQQ	ETF	164.26	164.64	163.91	164.5169	3634847.0
2018-04-17 10:00:00	QQQ	ETF	164.53	165.21	164.53	165.1899	4434213.0
2018-04-17 11:00:00	QQQ	ETF	165.19	165.741	165.19	165.545	4717753.0
2018-04-17 12:00:00	QQQ	ETF	165.56	165.99	165.56	165.79	2440694.0
2018-04-17 13:00:00	QQQ	ETF	165.7848	166.07	165.58	165.95	2687799.0
2018-04-17 14:00:00	QQQ	ETF	165.95	166.25	165.71	166.12	3023245.0
2018-04-17 15:00:00	QQQ	ETF	166.12	166.4592	165.91	166.0	8186227.0
2018-04-17 16:00:00	QQQ	ETF	166.01	166.14	165.96	165.97	2243969.0
2018-04-17 17:00:00	QQQ	ETF	166.06	166.1	165.83	165.88	228338.0
2018-04-17 18:00:00	QQQ	ETF	165.82	166.08	165.8	166.0	34122.0
2018-04-17 19:00:00	QQQ	ETF	166.04	166.23	166.02	166.14	39170.0
2018-04-17 04:00:00	IWM	ETF	156.0	156.0	155.75	156.0	4409.0
2018-04-17 05:00:00	IWM	ETF	155.93	155.95	155.93	155.95	11100.0
2018-04-17 06:00:00	IWM	ETF	156.0	156.14	156.0	156.1	3900.0
2018-04-17 07:00:00	IWM	ETF	156.03	156.1	155.96	156.03	9144.0
2018-04-17 08:00:00	IWM	ETF	156.03	156.23	156.03	156.2	28345.0
2018-04-17 09:00:00	IWM	ETF	156.17	156.4	155.96	156.26	1167668.0
2018-04-17 10:00:00	IWM	ETF	156.3	157.08	156.3	156.875	1893617.0
2018-04-17 11:00:00	IWM	ETF	156.89	157.23	156.875	156.9875	1662531.0
2018-04-17 12:00:00	IWM	ETF	156.985	157.28	156.835	156.92	1766447.0
2018-04-17 13:00:00	IWM	ETF	156.91	157.02	156.59	156.85	985246.0
2018-04-17 14:00:00	IWM	ETF	156.85	157.05	156.535	156.8	2073284.0
2018-04-17 15:00:00	IWM	ETF	156.79	157.49	156.78	157.01	4693804.0
2018-04-17 16:00:00	IWM	ETF	157.06	157.3	157.0	157.17	2089303.0
2018-04-17 17:00:00	IWM	ETF	157.11	157.27	157.0	157.02	10141.0
2018-04-17 18:00:00	IWM	ETF	157.07	157.29	157.06	157.24	22026.0
2018-04-17 19:00:00	IWM	ETF	157.29	157.33	157.29	157.31	2676.0
2018-04-17 04:00:00	DIA	ETF	246.42	247.02	246.42	246.99	2753.0
2018-04-17 05:00:00	DIA	ETF	247.16	247.16	247.06	247.06	500.0

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

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