PREVIEW / etf_1hour / 2019-07-16

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-16.parquet
  size:    324 KB
  rows:    10,817

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-07-16 04:00:00	SPY	ETF	300.82	300.9	300.82	300.9	689.0
2019-07-16 05:00:00	SPY	ETF	300.94	300.97	300.61	300.64	3284.0
2019-07-16 06:00:00	SPY	ETF	300.84	300.86	300.6	300.65	24867.0
2019-07-16 07:00:00	SPY	ETF	300.7	301.06	300.69	301.0	145317.0
2019-07-16 08:00:00	SPY	ETF	300.71	301.16	300.67	300.77	453996.0
2019-07-16 09:00:00	SPY	ETF	300.76	300.8591	300.4	300.66	2902597.0
2019-07-16 10:00:00	SPY	ETF	300.655	300.88	300.4	300.71	4254388.0
2019-07-16 11:00:00	SPY	ETF	300.72	300.75	300.045	300.075	5004964.0
2019-07-16 12:00:00	SPY	ETF	300.07	300.17	299.44	299.9	6058761.0
2019-07-16 13:00:00	SPY	ETF	299.9	300.32	299.55	299.59	4413883.0
2019-07-16 14:00:00	SPY	ETF	299.59	299.96	299.45	299.8	3724537.0
2019-07-16 15:00:00	SPY	ETF	299.795	300.155	299.62	299.74	9021743.0
2019-07-16 16:00:00	SPY	ETF	299.74	299.95	299.53	299.58	3793357.0
2019-07-16 17:00:00	SPY	ETF	299.61	299.71	299.5	299.62	79689.0
2019-07-16 18:00:00	SPY	ETF	299.61	299.75	299.43	299.74	68942.0
2019-07-16 19:00:00	SPY	ETF	299.66	299.7	299.61	299.64	26959.0
2019-07-16 04:00:00	QQQ	ETF	194.24	194.32	194.24	194.29	8800.0
2019-07-16 05:00:00	QQQ	ETF	194.3	194.3	194.06	194.1	5759.0
2019-07-16 06:00:00	QQQ	ETF	194.13	194.21	194.01	194.09	6491.0
2019-07-16 07:00:00	QQQ	ETF	194.12	194.34	194.07	194.21	129216.0
2019-07-16 08:00:00	QQQ	ETF	194.16	194.32	194.01	194.03	180060.0
2019-07-16 09:00:00	QQQ	ETF	194.01	194.09	193.71	194.0431	2196009.0
2019-07-16 10:00:00	QQQ	ETF	194.04	194.0499	193.61	193.87	1679632.0
2019-07-16 11:00:00	QQQ	ETF	193.87	193.91	193.4	193.44	1369195.0
2019-07-16 12:00:00	QQQ	ETF	193.43	193.51	192.56	193.22	3550909.0
2019-07-16 13:00:00	QQQ	ETF	193.21	193.569	192.845	192.87	1732544.0
2019-07-16 14:00:00	QQQ	ETF	192.87	193.25	192.83	193.14	1945092.0
2019-07-16 15:00:00	QQQ	ETF	193.14	193.4	193.04	193.13	3165575.0
2019-07-16 16:00:00	QQQ	ETF	193.14	193.19	192.88	192.91	1071023.0
2019-07-16 17:00:00	QQQ	ETF	192.98	192.98	192.87	192.88	9324.0
2019-07-16 18:00:00	QQQ	ETF	192.95	193.05	192.87	193.05	18106.0
2019-07-16 19:00:00	QQQ	ETF	193.0	193.01	192.91	192.96	22930.0
2019-07-16 05:00:00	IWM	ETF	155.23	155.23	155.23	155.23	1000.0
2019-07-16 06:00:00	IWM	ETF	155.25	155.25	155.12	155.12	5600.0
2019-07-16 07:00:00	IWM	ETF	155.19	155.28	155.12	155.24	4350.0
2019-07-16 08:00:00	IWM	ETF	155.36	155.44	155.16	155.2	26784.0
2019-07-16 09:00:00	IWM	ETF	155.23	155.52	154.67	155.45	1314608.0
2019-07-16 10:00:00	IWM	ETF	155.44	156.06	155.42	155.995	2111680.0
2019-07-16 11:00:00	IWM	ETF	156.0	156.2	155.56	155.56	1238990.0
2019-07-16 12:00:00	IWM	ETF	155.57	155.66	155.03	155.335	1824273.0
2019-07-16 13:00:00	IWM	ETF	155.34	156.08	155.33	155.38	1728379.0
2019-07-16 14:00:00	IWM	ETF	155.38	155.65	155.325	155.54	1186317.0
2019-07-16 15:00:00	IWM	ETF	155.55	155.61	155.24	155.27	2871663.0
2019-07-16 16:00:00	IWM	ETF	155.28	155.44	155.24	155.3	781896.0
2019-07-16 17:00:00	IWM	ETF	155.34	155.34	155.27	155.27	2352.0
2019-07-16 18:00:00	IWM	ETF	155.25	155.31	155.25	155.3	9626.0
2019-07-16 19:00:00	IWM	ETF	155.32	155.32	155.26	155.2901	2550.0
2019-07-16 07:00:00	DIA	ETF	273.71	273.88	273.64	273.88	35310.0
2019-07-16 08:00:00	DIA	ETF	273.94	274.03	273.64	273.64	39893.0
2019-07-16 09:00:00	DIA	ETF	273.68	273.9	273.37	273.6	254283.0

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

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