PREVIEW / etf_1hour / 2019-07-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-07-09.parquet
  size:    323 KB
  rows:    10,788

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-09 04:00:00	SPY	ETF	295.39	295.51	295.3	295.5	9455.0
2019-07-09 05:00:00	SPY	ETF	295.5	295.55	295.31	295.43	22275.0
2019-07-09 06:00:00	SPY	ETF	295.41	295.78	295.33	295.64	32463.0
2019-07-09 07:00:00	SPY	ETF	295.7	295.82	295.62	295.73	85021.0
2019-07-09 08:00:00	SPY	ETF	295.71	295.87	295.56	295.7301	362052.0
2019-07-09 09:00:00	SPY	ETF	295.74	296.9007	295.48	296.0749	5214454.0
2019-07-09 10:00:00	SPY	ETF	296.08	296.73	296.07	296.475	5743148.0
2019-07-09 11:00:00	SPY	ETF	296.47	296.86	296.41	296.64	4123750.0
2019-07-09 12:00:00	SPY	ETF	296.65	296.865	296.62	296.71	2101821.0
2019-07-09 13:00:00	SPY	ETF	296.71	296.83	296.59	296.79	2470142.0
2019-07-09 14:00:00	SPY	ETF	296.79	296.98	296.69	296.86	3026434.0
2019-07-09 15:00:00	SPY	ETF	296.86	297.52	296.55	297.26	11233665.0
2019-07-09 16:00:00	SPY	ETF	297.25	297.2677	296.9007	297.15	5220007.0
2019-07-09 17:00:00	SPY	ETF	297.13	297.19	297.0	297.07	127938.0
2019-07-09 18:00:00	SPY	ETF	297.07	297.15	297.01	297.05	31075.0
2019-07-09 19:00:00	SPY	ETF	297.04	297.1	296.95	297.08	26273.0
2019-07-09 04:00:00	QQQ	ETF	188.15	188.41	188.1	188.38	27657.0
2019-07-09 05:00:00	QQQ	ETF	188.31	188.41	188.19	188.39	17530.0
2019-07-09 06:00:00	QQQ	ETF	188.38	188.64	188.36	188.56	24718.0
2019-07-09 07:00:00	QQQ	ETF	188.53	188.82	188.53	188.82	85486.0
2019-07-09 08:00:00	QQQ	ETF	188.57	188.9099	188.3	188.85	113396.0
2019-07-09 09:00:00	QQQ	ETF	188.85	189.5	188.65	189.43	2895132.0
2019-07-09 10:00:00	QQQ	ETF	189.44	190.1197	189.43	189.94	2192093.0
2019-07-09 11:00:00	QQQ	ETF	189.93	190.32	189.8837	190.24	2006416.0
2019-07-09 12:00:00	QQQ	ETF	190.23	190.55	190.2	190.36	1471917.0
2019-07-09 13:00:00	QQQ	ETF	190.36	190.57	190.21	190.54	1935382.0
2019-07-09 14:00:00	QQQ	ETF	190.5499	190.63	190.43	190.58	1558814.0
2019-07-09 15:00:00	QQQ	ETF	190.57	190.9	190.26	190.69	3687429.0
2019-07-09 16:00:00	QQQ	ETF	190.68	190.73	190.48	190.62	973578.0
2019-07-09 17:00:00	QQQ	ETF	190.57	190.69	190.57	190.61	21558.0
2019-07-09 18:00:00	QQQ	ETF	190.62	190.67	190.58	190.6	12165.0
2019-07-09 19:00:00	QQQ	ETF	190.61	190.62	190.46	190.58	30293.0
2019-07-09 04:00:00	IWM	ETF	154.46	154.46	154.43	154.43	400.0
2019-07-09 05:00:00	IWM	ETF	154.44	154.49	154.44	154.48	4800.0
2019-07-09 06:00:00	IWM	ETF	154.52	154.71	154.52	154.71	963.0
2019-07-09 07:00:00	IWM	ETF	154.67	154.67	154.65	154.65	1300.0
2019-07-09 08:00:00	IWM	ETF	154.67	154.7099	154.61	154.65	40215.0
2019-07-09 09:00:00	IWM	ETF	154.62	155.05	154.52	154.7	1063223.0
2019-07-09 10:00:00	IWM	ETF	154.69	154.98	154.48	154.66	1929449.0
2019-07-09 11:00:00	IWM	ETF	154.64	154.885	154.5425	154.81	1275362.0
2019-07-09 12:00:00	IWM	ETF	154.8	155.09	154.75	154.87	822608.0
2019-07-09 13:00:00	IWM	ETF	154.88	154.92	154.65	154.7	812145.0
2019-07-09 14:00:00	IWM	ETF	154.69	155.04	154.64	154.97	1071438.0
2019-07-09 15:00:00	IWM	ETF	154.97	155.43	154.88	155.37	2535668.0
2019-07-09 16:00:00	IWM	ETF	155.37	155.42	155.27	155.3	1166866.0
2019-07-09 17:00:00	IWM	ETF	155.3	155.39	155.3	155.33	712.0
2019-07-09 18:00:00	IWM	ETF	155.3	155.3	155.26	155.26	4388.0
2019-07-09 19:00:00	IWM	ETF	155.28	155.29	155.18	155.29	7325.0
2019-07-09 04:00:00	DIA	ETF	267.09	267.09	267.09	267.09	206.0
2019-07-09 07:00:00	DIA	ETF	267.08	267.08	267.02	267.02	2300.0

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

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