PREVIEW / etf_1hour / 2019-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-09-20.parquet
  size:    331 KB
  rows:    10,750

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-09-20 04:00:00	SPY	ETF	300.5	300.5	299.94	299.95	13037.0
2019-09-20 05:00:00	SPY	ETF	299.96	300.34	299.96	300.34	12480.0
2019-09-20 06:00:00	SPY	ETF	300.3	300.5	300.17	300.19	28680.0
2019-09-20 07:00:00	SPY	ETF	300.21	300.29	300.04	300.29	94895.0
2019-09-20 08:00:00	SPY	ETF	300.2301	300.38	299.79	300.25	668914.0
2019-09-20 09:00:00	SPY	ETF	300.26	300.67	300.08	300.26	6483853.0
2019-09-20 10:00:00	SPY	ETF	300.28	300.64	300.08	300.23	11835347.0
2019-09-20 11:00:00	SPY	ETF	300.23	300.37	299.7031	300.119	7791719.0
2019-09-20 12:00:00	SPY	ETF	300.11	300.2499	299.73	300.015	4083084.0
2019-09-20 13:00:00	SPY	ETF	300.02	300.06	297.41	298.68	19065983.0
2019-09-20 14:00:00	SPY	ETF	298.67	299.23	298.48	298.9352	8084426.0
2019-09-20 15:00:00	SPY	ETF	298.94	299.155	298.09	298.13	15238796.0
2019-09-20 16:00:00	SPY	ETF	298.13	298.75	297.66	297.88	18172057.0
2019-09-20 17:00:00	SPY	ETF	297.9	299.75	297.63	297.65	3724876.0
2019-09-20 18:00:00	SPY	ETF	297.63	298.28	297.4	297.48	405233.0
2019-09-20 19:00:00	SPY	ETF	297.42	297.49	297.25	297.26	107707.0
2019-09-20 04:00:00	QQQ	ETF	193.25	193.25	193.01	193.05	15000.0
2019-09-20 05:00:00	QQQ	ETF	193.03	193.24	193.0	193.24	9795.0
2019-09-20 06:00:00	QQQ	ETF	193.28	193.4	193.16	193.2	25352.0
2019-09-20 07:00:00	QQQ	ETF	193.22	193.25	193.05	193.25	48225.0
2019-09-20 08:00:00	QQQ	ETF	193.15	193.44	192.84	193.33	199350.0
2019-09-20 09:00:00	QQQ	ETF	193.35	193.54	192.91	192.9225	2649119.0
2019-09-20 10:00:00	QQQ	ETF	192.94	193.2	192.58	192.6999	2534719.0
2019-09-20 11:00:00	QQQ	ETF	192.6906	192.76	191.89	192.26	2358217.0
2019-09-20 12:00:00	QQQ	ETF	192.26	192.38	191.72	192.0505	2016221.0
2019-09-20 13:00:00	QQQ	ETF	192.06	192.12	190.16	191.0	5935844.0
2019-09-20 14:00:00	QQQ	ETF	190.99	191.65	190.89	191.35	2462535.0
2019-09-20 15:00:00	QQQ	ETF	191.34	191.56	190.79	190.85	4203385.0
2019-09-20 16:00:00	QQQ	ETF	190.84	190.97	190.51	190.67	1393097.0
2019-09-20 17:00:00	QQQ	ETF	190.53	190.8	190.53	190.61	626828.0
2019-09-20 18:00:00	QQQ	ETF	190.61	190.8	190.54	190.66	83112.0
2019-09-20 19:00:00	QQQ	ETF	190.57	190.63	190.35	190.4	40368.0
2019-09-20 04:00:00	IWM	ETF	155.98	155.98	155.98	155.98	200.0
2019-09-20 06:00:00	IWM	ETF	156.31	156.31	156.25	156.25	7000.0
2019-09-20 07:00:00	IWM	ETF	156.1	156.14	155.98	156.05	142940.0
2019-09-20 08:00:00	IWM	ETF	156.07	156.15	155.85	155.95	99015.0
2019-09-20 09:00:00	IWM	ETF	155.93	156.19	155.56	155.92	1117606.0
2019-09-20 10:00:00	IWM	ETF	155.92	156.53	155.89	156.31	2243105.0
2019-09-20 11:00:00	IWM	ETF	156.285	156.41	155.8549	156.33	1649417.0
2019-09-20 12:00:00	IWM	ETF	156.33	156.65	156.2	156.365	1039412.0
2019-09-20 13:00:00	IWM	ETF	156.37	156.375	154.45	155.56	3987146.0
2019-09-20 14:00:00	IWM	ETF	155.57	155.77	155.33	155.57	1168570.0
2019-09-20 15:00:00	IWM	ETF	155.57	155.855	155.19	155.37	4698219.0
2019-09-20 16:00:00	IWM	ETF	155.39	155.58	155.21	155.48	1753176.0
2019-09-20 17:00:00	IWM	ETF	155.46	155.46	155.35	155.35	406300.0
2019-09-20 18:00:00	IWM	ETF	155.35	155.43	155.3	155.3	182800.0
2019-09-20 19:00:00	IWM	ETF	155.3	155.3	154.55	154.55	102365.0
2019-09-20 04:00:00	DIA	ETF	271.1	271.14	271.0	271.0	22000.0
2019-09-20 05:00:00	DIA	ETF	271.02	271.06	271.02	271.06	10000.0
2019-09-20 06:00:00	DIA	ETF	271.44	271.44	271.44	271.44	1000.0

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

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