PREVIEW / etf_1hour / 2019-08-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-29.parquet
  size:    339 KB
  rows:    11,020

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-08-29 04:00:00	SPY	ETF	290.86	291.18	290.57	290.94	54618.0
2019-08-29 05:00:00	SPY	ETF	291.15	291.76	291.15	291.59	59956.0
2019-08-29 06:00:00	SPY	ETF	291.68	291.98	291.56	291.93	111107.0
2019-08-29 07:00:00	SPY	ETF	291.88	291.97	291.47	291.84	448546.0
2019-08-29 08:00:00	SPY	ETF	291.84	292.02	288.4	291.62	706894.0
2019-08-29 09:00:00	SPY	ETF	291.63	292.6	291.43	292.32	9804618.0
2019-08-29 10:00:00	SPY	ETF	292.32	292.38	290.61	291.76	9859540.0
2019-08-29 11:00:00	SPY	ETF	291.76	292.73	291.57	292.525	6027306.0
2019-08-29 12:00:00	SPY	ETF	292.525	292.91	292.34	292.71	4206015.0
2019-08-29 13:00:00	SPY	ETF	292.72	293.05	292.5	292.94	3742489.0
2019-08-29 14:00:00	SPY	ETF	292.94	293.16	292.58	292.68	4645076.0
2019-08-29 15:00:00	SPY	ETF	292.7	292.83	292.24	292.56	11692793.0
2019-08-29 16:00:00	SPY	ETF	292.57	292.83	292.47	292.5	4818234.0
2019-08-29 17:00:00	SPY	ETF	292.56	292.56	292.4	292.43	53427.0
2019-08-29 18:00:00	SPY	ETF	292.45	292.76	292.28	292.39	618980.0
2019-08-29 19:00:00	SPY	ETF	292.44	292.49	292.18	292.46	62929.0
2019-08-29 04:00:00	QQQ	ETF	186.78	187.08	186.66	186.92	117760.0
2019-08-29 05:00:00	QQQ	ETF	186.99	187.51	186.99	187.4	31804.0
2019-08-29 06:00:00	QQQ	ETF	187.39	187.77	187.36	187.72	101783.0
2019-08-29 07:00:00	QQQ	ETF	187.69	187.74	187.3	187.46	362806.0
2019-08-29 08:00:00	QQQ	ETF	187.41	187.79	184.6	187.4	346626.0
2019-08-29 09:00:00	QQQ	ETF	187.39	188.34	187.25	188.1099	3673424.0
2019-08-29 10:00:00	QQQ	ETF	188.1	188.13	186.675	187.6103	4538600.0
2019-08-29 11:00:00	QQQ	ETF	187.599	188.21	187.49	187.972	1889122.0
2019-08-29 12:00:00	QQQ	ETF	187.975	188.26	187.82	188.06	2410880.0
2019-08-29 13:00:00	QQQ	ETF	188.07	188.39	187.96	188.3	1533362.0
2019-08-29 14:00:00	QQQ	ETF	188.32	188.4562	187.8901	187.99	2349388.0
2019-08-29 15:00:00	QQQ	ETF	187.98	188.09	187.68	187.91	4110318.0
2019-08-29 16:00:00	QQQ	ETF	187.92	188.1	187.84	187.9	949731.0
2019-08-29 17:00:00	QQQ	ETF	187.86	187.92	187.84	187.84	38123.0
2019-08-29 18:00:00	QQQ	ETF	187.84	187.87	187.57	187.76	66367.0
2019-08-29 19:00:00	QQQ	ETF	187.74	187.76	187.55	187.71	48439.0
2019-08-29 04:00:00	IWM	ETF	147.55	147.75	147.43	147.63	7415.0
2019-08-29 05:00:00	IWM	ETF	147.98	148.05	147.9	148.05	5995.0
2019-08-29 06:00:00	IWM	ETF	148.15	148.23	148.08	148.23	57265.0
2019-08-29 07:00:00	IWM	ETF	148.21	148.35	148.15	148.3	151823.0
2019-08-29 08:00:00	IWM	ETF	148.31	148.31	148.07	148.14	31463.0
2019-08-29 09:00:00	IWM	ETF	148.0	149.16	147.94	148.92	3406745.0
2019-08-29 10:00:00	IWM	ETF	148.93	149.195	148.26	148.84	3017316.0
2019-08-29 11:00:00	IWM	ETF	148.84	149.08	148.59	148.89	1596491.0
2019-08-29 12:00:00	IWM	ETF	148.89	149.09	148.82	149.0439	992463.0
2019-08-29 13:00:00	IWM	ETF	149.05	149.17	148.99	149.165	704271.0
2019-08-29 14:00:00	IWM	ETF	149.17	149.29	149.115	149.25	1233591.0
2019-08-29 15:00:00	IWM	ETF	149.26	149.27	148.85	149.11	3681207.0
2019-08-29 16:00:00	IWM	ETF	149.12	149.21	149.0	149.02	1296034.0
2019-08-29 17:00:00	IWM	ETF	149.03	149.04	149.02	149.04	600.0
2019-08-29 18:00:00	IWM	ETF	148.94	149.11	148.94	149.0	3214.0
2019-08-29 19:00:00	IWM	ETF	148.96	149.0	148.86	149.0	6430.0
2019-08-29 04:00:00	DIA	ETF	262.16	262.37	262.16	262.24	700.0
2019-08-29 05:00:00	DIA	ETF	262.56	262.92	262.56	262.9	1000.0

> showing 50 of 11,020 rows — these rows as CSV

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