PREVIEW / etf_1hour / 2018-01-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-25.parquet
  size:    310 KB
  rows:    10,194

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
2018-01-25 04:00:00	SPY	ETF	283.39	283.72	283.39	283.72	3890.0
2018-01-25 05:00:00	SPY	ETF	283.68	283.93	283.66	283.93	3606.0
2018-01-25 06:00:00	SPY	ETF	283.92	284.01	283.92	283.95	7466.0
2018-01-25 07:00:00	SPY	ETF	283.95	284.29	283.95	284.12	192320.0
2018-01-25 08:00:00	SPY	ETF	283.18	284.65	283.18	284.52	733696.0
2018-01-25 09:00:00	SPY	ETF	284.52	284.55	282.71	282.959	8223574.0
2018-01-25 10:00:00	SPY	ETF	282.96	283.63	282.71	283.32	10724840.0
2018-01-25 11:00:00	SPY	ETF	283.32	284.03	283.21	283.731	7517165.0
2018-01-25 12:00:00	SPY	ETF	283.7352	284.07	283.57	283.65	4946790.0
2018-01-25 13:00:00	SPY	ETF	283.65	283.92	283.36	283.78	3747741.0
2018-01-25 14:00:00	SPY	ETF	283.78	283.855	282.64	282.78	14165211.0
2018-01-25 15:00:00	SPY	ETF	282.78	283.38	282.405	283.28	18749293.0
2018-01-25 16:00:00	SPY	ETF	283.28	284.1651	283.24	283.54	10917603.0
2018-01-25 17:00:00	SPY	ETF	283.51	283.6	283.284	283.57	3134344.0
2018-01-25 18:00:00	SPY	ETF	283.57	283.67	283.45	283.6	199597.0
2018-01-25 19:00:00	SPY	ETF	283.66	283.8	283.61	283.65	23766.0
2018-01-25 04:00:00	QQQ	ETF	168.84	169.15	168.8	169.15	15200.0
2018-01-25 05:00:00	QQQ	ETF	169.13	169.29	168.97	169.29	5950.0
2018-01-25 06:00:00	QQQ	ETF	169.24	169.34	169.23	169.24	15680.0
2018-01-25 07:00:00	QQQ	ETF	169.25	169.51	169.24	169.41	171993.0
2018-01-25 08:00:00	QQQ	ETF	168.41	169.86	168.41	169.73	402214.0
2018-01-25 09:00:00	QQQ	ETF	169.72	169.78	168.16	168.33	5303827.0
2018-01-25 10:00:00	QQQ	ETF	168.34	168.89	168.19	168.75	5120850.0
2018-01-25 11:00:00	QQQ	ETF	168.76	169.31	168.67	169.2547	2450903.0
2018-01-25 12:00:00	QQQ	ETF	169.26	169.41	168.8099	168.82	2040049.0
2018-01-25 13:00:00	QQQ	ETF	168.82	169.11	168.57	169.011	1316661.0
2018-01-25 14:00:00	QQQ	ETF	169.02	169.04	168.0	168.13	3981981.0
2018-01-25 15:00:00	QQQ	ETF	168.13	168.45	167.81	168.35	5181576.0
2018-01-25 16:00:00	QQQ	ETF	168.35	168.69	168.3	168.67	539251.0
2018-01-25 17:00:00	QQQ	ETF	168.58	168.67	168.58	168.67	2676.0
2018-01-25 18:00:00	QQQ	ETF	168.66	168.8	168.62	168.78	25948.0
2018-01-25 19:00:00	QQQ	ETF	168.78	168.87	168.78	168.8	15509.0
2018-01-25 04:00:00	IWM	ETF	159.22	159.47	159.22	159.47	3431.0
2018-01-25 05:00:00	IWM	ETF	159.47	159.52	159.47	159.52	6100.0
2018-01-25 06:00:00	IWM	ETF	159.58	159.69	159.58	159.68	7760.0
2018-01-25 07:00:00	IWM	ETF	159.65	159.88	159.65	159.67	48275.0
2018-01-25 08:00:00	IWM	ETF	158.97	159.97	158.97	159.91	264131.0
2018-01-25 09:00:00	IWM	ETF	159.89	159.97	158.39	158.64	2848771.0
2018-01-25 10:00:00	IWM	ETF	158.63	158.8	158.21	158.37	2682832.0
2018-01-25 11:00:00	IWM	ETF	158.38	159.045	158.26	158.9962	2264811.0
2018-01-25 12:00:00	IWM	ETF	158.9999	159.22	158.74	158.83	1105464.0
2018-01-25 13:00:00	IWM	ETF	158.84	159.13	158.67	159.025	981180.0
2018-01-25 14:00:00	IWM	ETF	159.02	159.085	158.33	158.46	1868160.0
2018-01-25 15:00:00	IWM	ETF	158.46	159.09	158.21	159.03	4047071.0
2018-01-25 16:00:00	IWM	ETF	159.03	159.23	158.6682	159.17	1662124.0
2018-01-25 17:00:00	IWM	ETF	159.21	159.27	158.9823	159.27	86733.0
2018-01-25 18:00:00	IWM	ETF	159.2	159.26	159.12	159.26	2853.0
2018-01-25 19:00:00	IWM	ETF	159.29	159.29	159.21	159.27	3410.0
2018-01-25 05:00:00	DIA	ETF	262.95	262.95	262.95	262.95	200.0
2018-01-25 07:00:00	DIA	ETF	263.26	263.72	263.26	263.7	4341.0

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

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