PREVIEW / etf_1hour / 2019-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-08.parquet
  size:    314 KB
  rows:    10,360

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
2019-02-08 04:00:00	SPY	ETF	269.45	269.62	269.24	269.31	12699.0
2019-02-08 05:00:00	SPY	ETF	269.31	269.36	269.01	269.2	25148.0
2019-02-08 06:00:00	SPY	ETF	269.26	269.3	268.51	268.58	74824.0
2019-02-08 07:00:00	SPY	ETF	268.62	268.72	268.43	268.58	254820.0
2019-02-08 08:00:00	SPY	ETF	268.53	269.3	268.45	268.72	544796.0
2019-02-08 09:00:00	SPY	ETF	268.75	269.44	268.51	268.6399	8146974.0
2019-02-08 10:00:00	SPY	ETF	268.64	270.2874	268.09	268.345	12192295.0
2019-02-08 11:00:00	SPY	ETF	268.34	268.68	267.83	268.61	10592548.0
2019-02-08 12:00:00	SPY	ETF	268.61	269.02	268.23	268.87	5514024.0
2019-02-08 13:00:00	SPY	ETF	268.86	269.35	268.835	269.2801	5499366.0
2019-02-08 14:00:00	SPY	ETF	269.29	270.2874	269.13	269.58	7796323.0
2019-02-08 15:00:00	SPY	ETF	269.59	270.51	269.405	270.49	15996650.0
2019-02-08 16:00:00	SPY	ETF	270.48	270.61	270.23	270.56	8202189.0
2019-02-08 17:00:00	SPY	ETF	270.56	270.56	270.33	270.49	227552.0
2019-02-08 18:00:00	SPY	ETF	270.51	270.53	270.42	270.43	22877.0
2019-02-08 19:00:00	SPY	ETF	270.46	270.5	270.4	270.5	13393.0
2019-02-08 04:00:00	QQQ	ETF	167.45	167.6	167.28	167.32	23620.0
2019-02-08 05:00:00	QQQ	ETF	167.37	167.38	167.2	167.3	19750.0
2019-02-08 06:00:00	QQQ	ETF	167.33	167.39	166.7	166.77	43820.0
2019-02-08 07:00:00	QQQ	ETF	166.8	166.87	166.6	166.67	200329.0
2019-02-08 08:00:00	QQQ	ETF	168.23	168.23	166.63	166.76	256212.0
2019-02-08 09:00:00	QQQ	ETF	166.79	167.45	166.67	166.82	4303043.0
2019-02-08 10:00:00	QQQ	ETF	166.81	167.59	166.57	167.15	5825492.0
2019-02-08 11:00:00	QQQ	ETF	167.15	167.3525	166.62	167.3	3339291.0
2019-02-08 12:00:00	QQQ	ETF	167.29	167.47	166.86	167.35	1863090.0
2019-02-08 13:00:00	QQQ	ETF	167.36	167.855	167.35	167.8185	1714929.0
2019-02-08 14:00:00	QQQ	ETF	167.82	168.31	167.72	168.08	2656751.0
2019-02-08 15:00:00	QQQ	ETF	168.08	168.51	167.9	168.51	4695149.0
2019-02-08 16:00:00	QQQ	ETF	168.52	168.62	168.36	168.58	1195541.0
2019-02-08 17:00:00	QQQ	ETF	168.57	168.57	168.42	168.46	42207.0
2019-02-08 18:00:00	QQQ	ETF	168.59	168.59	168.46	168.5	17262.0
2019-02-08 19:00:00	QQQ	ETF	168.48	168.6	168.48	168.6	9347.0
2019-02-08 04:00:00	IWM	ETF	149.34	149.34	149.34	149.34	100.0
2019-02-08 05:00:00	IWM	ETF	149.17	149.21	149.17	149.19	3000.0
2019-02-08 06:00:00	IWM	ETF	149.25	149.25	148.88	148.89	14907.0
2019-02-08 07:00:00	IWM	ETF	148.86	149.0	148.81	148.84	27855.0
2019-02-08 08:00:00	IWM	ETF	148.89	149.15	148.89	149.01	45715.0
2019-02-08 09:00:00	IWM	ETF	149.0	149.86	148.97	149.41	1999289.0
2019-02-08 10:00:00	IWM	ETF	149.41	149.61	148.91	148.94	2109800.0
2019-02-08 11:00:00	IWM	ETF	148.95	149.1	148.5	148.99	1680307.0
2019-02-08 12:00:00	IWM	ETF	148.9947	149.22	148.62	149.11	914405.0
2019-02-08 13:00:00	IWM	ETF	149.11	149.41	149.04	149.38	918587.0
2019-02-08 14:00:00	IWM	ETF	149.38	149.82	149.29	149.63	1303336.0
2019-02-08 15:00:00	IWM	ETF	149.62	149.87	149.55	149.85	2447682.0
2019-02-08 16:00:00	IWM	ETF	149.85	150.04	149.83	150.02	531974.0
2019-02-08 17:00:00	IWM	ETF	149.91	150.0	149.91	150.0	2837.0
2019-02-08 18:00:00	IWM	ETF	150.04	150.05	149.95	149.95	8236.0
2019-02-08 19:00:00	IWM	ETF	149.98	149.99	149.98	149.99	400.0
2019-02-08 04:00:00	DIA	ETF	251.21	251.3	251.21	251.26	308.0
2019-02-08 06:00:00	DIA	ETF	250.92	250.92	250.92	250.92	100.0

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

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