PREVIEW / etf_1hour / 2019-02-14

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-14.parquet
  size:    318 KB
  rows:    10,663

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-02-14 04:00:00	SPY	ETF	275.45	275.75	275.38	275.5	23630.0
2019-02-14 05:00:00	SPY	ETF	275.55	275.63	275.25	275.44	15160.0
2019-02-14 06:00:00	SPY	ETF	275.5	275.7	275.5	275.56	46208.0
2019-02-14 07:00:00	SPY	ETF	275.55	275.82	275.42	275.73	185213.0
2019-02-14 08:00:00	SPY	ETF	275.35	275.95	273.95	274.01	1641370.0
2019-02-14 09:00:00	SPY	ETF	274.05	274.05	272.87	273.79	12817497.0
2019-02-14 10:00:00	SPY	ETF	273.78	274.67	273.39	274.01	18874689.0
2019-02-14 11:00:00	SPY	ETF	274.0064	274.41	273.48	274.34	6885530.0
2019-02-14 12:00:00	SPY	ETF	274.34	275.35	274.2	275.085	7696702.0
2019-02-14 13:00:00	SPY	ETF	275.1	275.22	274.84	274.98	5070958.0
2019-02-14 14:00:00	SPY	ETF	274.99	275.29	274.67	274.832	8194910.0
2019-02-14 15:00:00	SPY	ETF	274.85	275.64	274.29	274.38	15971541.0
2019-02-14 16:00:00	SPY	ETF	274.4	274.52	274.0	274.0	3759589.0
2019-02-14 17:00:00	SPY	ETF	273.99	274.3754	273.97	274.03	567896.0
2019-02-14 18:00:00	SPY	ETF	274.0	274.3772	273.82	274.1	589537.0
2019-02-14 19:00:00	SPY	ETF	274.08	274.1	273.47	273.6	143613.0
2019-02-14 04:00:00	QQQ	ETF	171.45	171.71	171.45	171.57	21430.0
2019-02-14 05:00:00	QQQ	ETF	171.61	171.65	171.37	171.45	19296.0
2019-02-14 06:00:00	QQQ	ETF	171.53	171.65	171.53	171.53	10050.0
2019-02-14 07:00:00	QQQ	ETF	171.55	171.73	171.51	171.64	99966.0
2019-02-14 08:00:00	QQQ	ETF	171.52	171.84	170.46	170.52	545727.0
2019-02-14 09:00:00	QQQ	ETF	170.54	170.76	169.83	170.72	4782669.0
2019-02-14 10:00:00	QQQ	ETF	170.71	171.23	170.25	170.74	6539479.0
2019-02-14 11:00:00	QQQ	ETF	170.75	171.09	170.36	170.99	2411792.0
2019-02-14 12:00:00	QQQ	ETF	170.99	171.73	170.87	171.59	2822908.0
2019-02-14 13:00:00	QQQ	ETF	171.6	171.68	171.3301	171.4	1053442.0
2019-02-14 14:00:00	QQQ	ETF	171.395	171.66	171.23	171.33	1406889.0
2019-02-14 15:00:00	QQQ	ETF	171.34	171.83	171.12	171.17	3862245.0
2019-02-14 16:00:00	QQQ	ETF	171.18	171.37	170.78	170.99	1367927.0
2019-02-14 17:00:00	QQQ	ETF	170.83	171.2385	170.83	171.03	196352.0
2019-02-14 18:00:00	QQQ	ETF	170.99	171.07	170.81	170.96	24986.0
2019-02-14 19:00:00	QQQ	ETF	170.91	170.95	170.51	170.62	92314.0
2019-02-14 04:00:00	IWM	ETF	153.66	153.75	153.65	153.65	900.0
2019-02-14 05:00:00	IWM	ETF	153.63	153.64	153.58	153.58	3470.0
2019-02-14 06:00:00	IWM	ETF	153.63	153.63	153.63	153.63	2000.0
2019-02-14 07:00:00	IWM	ETF	153.6	153.73	153.55	153.68	31047.0
2019-02-14 08:00:00	IWM	ETF	153.73	153.78	152.84	152.88	57471.0
2019-02-14 09:00:00	IWM	ETF	152.84	153.2	152.4	153.12	2725868.0
2019-02-14 10:00:00	IWM	ETF	153.1	153.63	152.85	153.48	3429916.0
2019-02-14 11:00:00	IWM	ETF	153.49	153.87	153.05	153.85	2527519.0
2019-02-14 12:00:00	IWM	ETF	153.86	154.11	153.7375	154.05	1586351.0
2019-02-14 13:00:00	IWM	ETF	154.06	154.09	153.86	153.92	885884.0
2019-02-14 14:00:00	IWM	ETF	153.92	154.15	153.85	153.99	1123251.0
2019-02-14 15:00:00	IWM	ETF	154.0	154.37	153.62	153.77	3705305.0
2019-02-14 16:00:00	IWM	ETF	153.6867	153.83	153.53	153.66	995900.0
2019-02-14 17:00:00	IWM	ETF	153.51	153.7715	153.51	153.58	98691.0
2019-02-14 18:00:00	IWM	ETF	153.53	153.62	153.38	153.62	6160.0
2019-02-14 19:00:00	IWM	ETF	153.5	153.5	153.23	153.39	3700.0
2019-02-14 04:00:00	DIA	ETF	255.62	256.46	255.62	256.46	500.0
2019-02-14 05:00:00	DIA	ETF	256.26	256.3	256.2	256.2	400.0

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

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