PREVIEW / etf_1hour / 2019-02-06

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-06.parquet
  size:    316 KB
  rows:    10,501

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-06 04:00:00	SPY	ETF	272.34	272.36	272.19	272.32	7014.0
2019-02-06 05:00:00	SPY	ETF	272.28	272.44	272.27	272.42	14153.0
2019-02-06 06:00:00	SPY	ETF	272.42	272.74	272.42	272.5	69593.0
2019-02-06 07:00:00	SPY	ETF	272.46	272.74	272.46	272.57	56497.0
2019-02-06 08:00:00	SPY	ETF	272.7101	273.0	272.36	272.9	182392.0
2019-02-06 09:00:00	SPY	ETF	272.9	273.34	272.65	272.79	5941329.0
2019-02-06 10:00:00	SPY	ETF	272.8	273.19	271.92	273.04	9553257.0
2019-02-06 11:00:00	SPY	ETF	273.04	273.24	272.3466	272.67	6663677.0
2019-02-06 12:00:00	SPY	ETF	272.67	272.86	272.36	272.745	3125542.0
2019-02-06 13:00:00	SPY	ETF	272.74	273.05	272.73	272.765	2795019.0
2019-02-06 14:00:00	SPY	ETF	272.76	272.8	272.21	272.6	6995124.0
2019-02-06 15:00:00	SPY	ETF	272.59	272.86	272.49	272.75	10761682.0
2019-02-06 16:00:00	SPY	ETF	272.78	272.91	272.45	272.45	8739245.0
2019-02-06 17:00:00	SPY	ETF	272.45	272.74	272.34	272.34	171986.0
2019-02-06 18:00:00	SPY	ETF	272.37	272.54	272.32	272.48	206964.0
2019-02-06 19:00:00	SPY	ETF	272.49	272.54	272.22	272.36	51717.0
2019-02-06 04:00:00	QQQ	ETF	170.5	170.5	170.21	170.31	20159.0
2019-02-06 05:00:00	QQQ	ETF	170.33	170.47	170.32	170.38	18237.0
2019-02-06 06:00:00	QQQ	ETF	170.47	170.59	170.45	170.53	12817.0
2019-02-06 07:00:00	QQQ	ETF	170.52	170.81	170.51	170.66	57277.0
2019-02-06 08:00:00	QQQ	ETF	170.71	171.1	170.51	171.03	249067.0
2019-02-06 09:00:00	QQQ	ETF	171.04	171.37	170.71	170.88	3468503.0
2019-02-06 10:00:00	QQQ	ETF	170.88	171.03	169.75	170.88	5483024.0
2019-02-06 11:00:00	QQQ	ETF	170.8766	171.02	170.355	170.49	3507585.0
2019-02-06 12:00:00	QQQ	ETF	170.49	170.6	170.17	170.46	1808653.0
2019-02-06 13:00:00	QQQ	ETF	170.45	170.75	170.38	170.43	1238732.0
2019-02-06 14:00:00	QQQ	ETF	170.4231	170.46	170.03	170.4001	1898604.0
2019-02-06 15:00:00	QQQ	ETF	170.4	170.65	170.33	170.5	2908477.0
2019-02-06 16:00:00	QQQ	ETF	170.5	170.62	170.17	170.18	4249042.0
2019-02-06 17:00:00	QQQ	ETF	170.05	170.25	170.05	170.18	49697.0
2019-02-06 18:00:00	QQQ	ETF	170.17	170.29	170.09	170.23	25094.0
2019-02-06 19:00:00	QQQ	ETF	170.29	170.29	169.99	170.09	61160.0
2019-02-06 04:00:00	IWM	ETF	150.7	150.7	150.6	150.6	1084.0
2019-02-06 05:00:00	IWM	ETF	150.72	150.72	150.72	150.72	100.0
2019-02-06 06:00:00	IWM	ETF	150.83	150.89	150.83	150.89	3000.0
2019-02-06 07:00:00	IWM	ETF	150.98	151.03	150.98	151.03	7126.0
2019-02-06 08:00:00	IWM	ETF	150.99	151.15	150.95	151.06	59112.0
2019-02-06 09:00:00	IWM	ETF	151.06	151.37	150.74	150.76	1351295.0
2019-02-06 10:00:00	IWM	ETF	150.76	150.8299	150.1	150.73	2994824.0
2019-02-06 11:00:00	IWM	ETF	150.725	151.1499	150.4599	150.95	2044008.0
2019-02-06 12:00:00	IWM	ETF	150.91	150.98	150.62	150.86	1010526.0
2019-02-06 13:00:00	IWM	ETF	150.85	151.14	150.77	150.77	943038.0
2019-02-06 14:00:00	IWM	ETF	150.77	150.97	150.69	150.82	1317351.0
2019-02-06 15:00:00	IWM	ETF	150.82	151.02	150.76	150.92	1875101.0
2019-02-06 16:00:00	IWM	ETF	150.94	150.96	150.76	150.86	990729.0
2019-02-06 17:00:00	IWM	ETF	150.86	150.93	150.7501	150.93	74777.0
2019-02-06 18:00:00	IWM	ETF	150.81	150.81	150.75	150.8	3243.0
2019-02-06 19:00:00	IWM	ETF	150.82	150.82	150.67	150.73	5200.0
2019-02-06 04:00:00	DIA	ETF	253.26	253.26	253.26	253.26	100.0
2019-02-06 07:00:00	DIA	ETF	253.42	253.61	253.42	253.61	300.0

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

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