PREVIEW / etf_1hour / 2019-07-17

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-17.parquet
  size:    327 KB
  rows:    10,748

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-17 04:00:00	SPY	ETF	300.03	300.33	300.03	300.06	25323.0
2019-07-17 05:00:00	SPY	ETF	300.06	300.25	300.06	300.2	12350.0
2019-07-17 06:00:00	SPY	ETF	300.26	300.26	299.89	299.89	10376.0
2019-07-17 07:00:00	SPY	ETF	299.93	299.93	299.63	299.92	76483.0
2019-07-17 08:00:00	SPY	ETF	299.8585	299.95	299.58	299.64	323935.0
2019-07-17 09:00:00	SPY	ETF	299.62	299.93	299.4	299.545	3345497.0
2019-07-17 10:00:00	SPY	ETF	299.55	299.67	298.33	298.695	6811669.0
2019-07-17 11:00:00	SPY	ETF	298.69	299.25	298.66	299.08	4595216.0
2019-07-17 12:00:00	SPY	ETF	299.08	299.12	298.77	298.94	2314593.0
2019-07-17 13:00:00	SPY	ETF	298.94	299.13	298.75	298.99	3000501.0
2019-07-17 14:00:00	SPY	ETF	298.98	298.9904	298.45	298.603	3289877.0
2019-07-17 15:00:00	SPY	ETF	298.605	298.6762	297.76	297.77	10441310.0
2019-07-17 16:00:00	SPY	ETF	297.79	298.07	297.11	297.2	7720510.0
2019-07-17 17:00:00	SPY	ETF	297.2	297.74	297.11	297.11	202074.0
2019-07-17 18:00:00	SPY	ETF	297.19	297.45	297.19	297.33	108447.0
2019-07-17 19:00:00	SPY	ETF	297.33	297.39	297.14	297.23	92073.0
2019-07-17 04:00:00	QQQ	ETF	193.31	193.5	193.31	193.42	9834.0
2019-07-17 05:00:00	QQQ	ETF	193.43	193.54	193.43	193.54	3471.0
2019-07-17 06:00:00	QQQ	ETF	193.53	193.53	193.25	193.3	13050.0
2019-07-17 07:00:00	QQQ	ETF	193.34	193.34	193.09	193.3	26766.0
2019-07-17 08:00:00	QQQ	ETF	193.1901	193.34	193.0	193.09	76363.0
2019-07-17 09:00:00	QQQ	ETF	193.08	193.49	193.0	193.35	1515339.0
2019-07-17 10:00:00	QQQ	ETF	193.36	193.44	192.49	192.76	2222863.0
2019-07-17 11:00:00	QQQ	ETF	192.78	193.13	192.69	193.0	1411692.0
2019-07-17 12:00:00	QQQ	ETF	193.01	193.09	192.82	193.02	897980.0
2019-07-17 13:00:00	QQQ	ETF	193.03	193.1	192.85	193.07	1248908.0
2019-07-17 14:00:00	QQQ	ETF	193.07	193.09	192.7	192.9061	892347.0
2019-07-17 15:00:00	QQQ	ETF	192.9	192.94	192.18	192.19	4160145.0
2019-07-17 16:00:00	QQQ	ETF	192.2	192.43	191.21	191.25	1817103.0
2019-07-17 17:00:00	QQQ	ETF	191.24	192.2	191.18	191.2	185300.0
2019-07-17 18:00:00	QQQ	ETF	191.3	191.51	191.29	191.44	179183.0
2019-07-17 19:00:00	QQQ	ETF	191.4	191.41	191.25	191.31	40061.0
2019-07-17 05:00:00	IWM	ETF	155.59	155.6	155.59	155.6	6000.0
2019-07-17 06:00:00	IWM	ETF	155.65	155.65	155.44	155.45	7000.0
2019-07-17 07:00:00	IWM	ETF	155.48	155.48	155.31	155.46	15915.0
2019-07-17 08:00:00	IWM	ETF	155.34	155.49	155.21	155.21	33788.0
2019-07-17 09:00:00	IWM	ETF	155.2	155.34	154.24	154.64	1849503.0
2019-07-17 10:00:00	IWM	ETF	154.64	154.85	153.73	154.038	2437103.0
2019-07-17 11:00:00	IWM	ETF	154.04	155.12	154.03	154.94	2073973.0
2019-07-17 12:00:00	IWM	ETF	154.95	154.98	154.55	154.555	838058.0
2019-07-17 13:00:00	IWM	ETF	154.56	154.81	154.465	154.75	614203.0
2019-07-17 14:00:00	IWM	ETF	154.74	154.75	154.35	154.4125	1022041.0
2019-07-17 15:00:00	IWM	ETF	154.41	154.53	154.14	154.17	3228709.0
2019-07-17 16:00:00	IWM	ETF	154.18	154.34	153.85	153.86	951969.0
2019-07-17 17:00:00	IWM	ETF	153.85	154.13	153.7399	153.74	120559.0
2019-07-17 18:00:00	IWM	ETF	153.74	153.97	153.74	153.94	23357.0
2019-07-17 19:00:00	IWM	ETF	153.97	153.97	153.89	153.93	13222.0
2019-07-17 04:00:00	DIA	ETF	273.72	273.72	273.72	273.72	100.0
2019-07-17 07:00:00	DIA	ETF	273.5	273.5	273.5	273.5	1663.0
2019-07-17 08:00:00	DIA	ETF	273.52	273.62	273.28	273.44	5766.0

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

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