PREVIEW / etf_1hour / 2018-06-13

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-13.parquet
  size:    295 KB
  rows:    9,664

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-06-13 04:00:00	SPY	ETF	278.97	279.02	278.91	278.99	7386.0
2018-06-13 05:00:00	SPY	ETF	279.06	279.2	278.99	279.14	1912.0
2018-06-13 06:00:00	SPY	ETF	279.2	279.3	279.15	279.27	55676.0
2018-06-13 07:00:00	SPY	ETF	279.28	279.34	279.2	279.24	98898.0
2018-06-13 08:00:00	SPY	ETF	279.29	279.3399	278.92	279.12	315930.0
2018-06-13 09:00:00	SPY	ETF	279.11	279.29	279.005	279.06	5737447.0
2018-06-13 10:00:00	SPY	ETF	279.06	279.45	279.0575	279.19	6647238.0
2018-06-13 11:00:00	SPY	ETF	279.2	279.48	279.2	279.35	5348618.0
2018-06-13 12:00:00	SPY	ETF	279.35	279.38	279.01	279.01	5126818.0
2018-06-13 13:00:00	SPY	ETF	279.01	279.15	278.9	279.0989	5325992.0
2018-06-13 14:00:00	SPY	ETF	279.09	279.17	278.04	278.75	16072120.0
2018-06-13 15:00:00	SPY	ETF	278.7475	279.25	277.8	277.92	21356625.0
2018-06-13 16:00:00	SPY	ETF	277.95	278.25	277.78	277.92	10832770.0
2018-06-13 17:00:00	SPY	ETF	277.9	278.03	277.83	277.83	92877.0
2018-06-13 18:00:00	SPY	ETF	277.81	278.03	277.78	278.0	141556.0
2018-06-13 19:00:00	SPY	ETF	278.03	278.05	277.87	278.02	26587.0
2018-06-13 04:00:00	QQQ	ETF	175.94	175.94	175.73	175.86	7800.0
2018-06-13 05:00:00	QQQ	ETF	175.91	176.08	175.84	176.03	11100.0
2018-06-13 06:00:00	QQQ	ETF	176.07	176.2	175.99	176.14	20800.0
2018-06-13 07:00:00	QQQ	ETF	176.14	176.19	176.05	176.07	74433.0
2018-06-13 08:00:00	QQQ	ETF	176.12	176.15	175.9	175.97	89739.0
2018-06-13 09:00:00	QQQ	ETF	175.98	176.33	175.94	176.23	1986059.0
2018-06-13 10:00:00	QQQ	ETF	176.23	176.71	176.23	176.51	4098323.0
2018-06-13 11:00:00	QQQ	ETF	176.52	177.14	176.52	176.975	2700920.0
2018-06-13 12:00:00	QQQ	ETF	176.98	177.0	176.57	176.68	2083233.0
2018-06-13 13:00:00	QQQ	ETF	176.68	176.86	176.51	176.74	1830612.0
2018-06-13 14:00:00	QQQ	ETF	176.76	176.78	175.43	176.38	10081318.0
2018-06-13 15:00:00	QQQ	ETF	176.3701	176.76	175.65	175.77	7699317.0
2018-06-13 16:00:00	QQQ	ETF	175.76	175.96	175.64	175.79	1248386.0
2018-06-13 17:00:00	QQQ	ETF	175.71	175.92	175.71	175.75	3834.0
2018-06-13 18:00:00	QQQ	ETF	175.75	175.92	175.73	175.85	25533.0
2018-06-13 19:00:00	QQQ	ETF	175.9	175.92	175.71	175.79	32757.0
2018-06-13 04:00:00	IWM	ETF	167.64	167.64	167.63	167.63	2000.0
2018-06-13 05:00:00	IWM	ETF	167.72	167.72	167.72	167.72	300.0
2018-06-13 06:00:00	IWM	ETF	167.76	167.8	167.75	167.75	5585.0
2018-06-13 07:00:00	IWM	ETF	167.75	167.8	167.72	167.72	65850.0
2018-06-13 08:00:00	IWM	ETF	167.75	167.75	167.63	167.66	13745.0
2018-06-13 09:00:00	IWM	ETF	167.68	167.77	167.485	167.55	1824479.0
2018-06-13 10:00:00	IWM	ETF	167.55	167.7	167.33	167.48	2192683.0
2018-06-13 11:00:00	IWM	ETF	167.48	167.87	167.48	167.54	1562498.0
2018-06-13 12:00:00	IWM	ETF	167.54	167.54	166.9	166.9	1609519.0
2018-06-13 13:00:00	IWM	ETF	166.9	167.13	166.82	167.02	1307933.0
2018-06-13 14:00:00	IWM	ETF	167.035	167.22	166.62	167.22	3302745.0
2018-06-13 15:00:00	IWM	ETF	167.21	167.455	166.84	166.9	3484406.0
2018-06-13 16:00:00	IWM	ETF	166.9	167.09	166.79	166.89	1469650.0
2018-06-13 17:00:00	IWM	ETF	166.84	166.86	166.8	166.86	2604.0
2018-06-13 18:00:00	IWM	ETF	166.89	166.98	166.89	166.92	7500.0
2018-06-13 19:00:00	IWM	ETF	166.95	166.95	166.86	166.9	5185.0
2018-06-13 05:00:00	DIA	ETF	253.3	253.3	253.3	253.3	172.0
2018-06-13 07:00:00	DIA	ETF	253.4	253.57	253.4	253.57	859.0

> showing 50 of 9,664 rows — these rows as CSV

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