PREVIEW / etf_1hour / 2018-12-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-17.parquet
  size:    342 KB
  rows:    11,053

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-12-17 04:00:00	SPY	ETF	260.99	260.99	260.57	260.78	21141.0
2018-12-17 05:00:00	SPY	ETF	260.82	261.28	260.71	260.72	37211.0
2018-12-17 06:00:00	SPY	ETF	260.73	260.78	260.17	260.44	51859.0
2018-12-17 07:00:00	SPY	ETF	260.4	260.58	259.88	259.98	196439.0
2018-12-17 08:00:00	SPY	ETF	260.0	261.58	259.22	259.29	613582.0
2018-12-17 09:00:00	SPY	ETF	259.31	259.66	257.241	258.4501	13246864.0
2018-12-17 10:00:00	SPY	ETF	258.44	259.8	258.0015	259.55	17839474.0
2018-12-17 11:00:00	SPY	ETF	259.56	260.65	259.4	260.3485	13308534.0
2018-12-17 12:00:00	SPY	ETF	260.35	260.64	257.65	257.67	12407000.0
2018-12-17 13:00:00	SPY	ETF	257.66	258.14	256.33	256.39	18879731.0
2018-12-17 14:00:00	SPY	ETF	256.37	256.8	255.57	255.875	22385496.0
2018-12-17 15:00:00	SPY	ETF	255.88	256.2123	253.525	255.28	46627097.0
2018-12-17 16:00:00	SPY	ETF	255.34	256.0	255.036	255.78	15062182.0
2018-12-17 17:00:00	SPY	ETF	255.88	255.92	255.17	255.92	1854452.0
2018-12-17 18:00:00	SPY	ETF	255.91	256.6	255.75	256.41	200002.0
2018-12-17 19:00:00	SPY	ETF	256.4	256.4	255.8	256.33	105323.0
2018-12-17 04:00:00	QQQ	ETF	161.4	161.4	161.0	161.2	12740.0
2018-12-17 05:00:00	QQQ	ETF	161.41	161.65	161.28	161.28	14478.0
2018-12-17 06:00:00	QQQ	ETF	161.24	161.25	160.75	160.97	40215.0
2018-12-17 07:00:00	QQQ	ETF	160.91	161.11	160.58	160.65	151763.0
2018-12-17 08:00:00	QQQ	ETF	160.68	161.8	160.17	160.27	370773.0
2018-12-17 09:00:00	QQQ	ETF	160.23	160.55	158.64	159.42	8611184.0
2018-12-17 10:00:00	QQQ	ETF	159.41	160.88	159.23	160.59	7382151.0
2018-12-17 11:00:00	QQQ	ETF	160.6	161.41	160.51	161.35	5990408.0
2018-12-17 12:00:00	QQQ	ETF	161.35	161.67	159.55	159.56	4784767.0
2018-12-17 13:00:00	QQQ	ETF	159.55	159.86	158.28	158.38	7455634.0
2018-12-17 14:00:00	QQQ	ETF	158.38	158.56	157.61	157.8666	8652481.0
2018-12-17 15:00:00	QQQ	ETF	157.85	157.96	156.17	157.52	18428593.0
2018-12-17 16:00:00	QQQ	ETF	157.54	157.99	157.36	157.85	2444350.0
2018-12-17 17:00:00	QQQ	ETF	157.83	158.0	157.43	157.97	208870.0
2018-12-17 18:00:00	QQQ	ETF	157.92	158.4	157.84	158.4	66056.0
2018-12-17 19:00:00	QQQ	ETF	158.35	158.38	158.03	158.37	61083.0
2018-12-17 04:00:00	IWM	ETF	140.76	140.76	140.29	140.29	9200.0
2018-12-17 05:00:00	IWM	ETF	140.65	140.65	140.43	140.43	1227.0
2018-12-17 06:00:00	IWM	ETF	140.41	140.41	140.15	140.21	7450.0
2018-12-17 07:00:00	IWM	ETF	140.24	140.29	140.0	140.0	22195.0
2018-12-17 08:00:00	IWM	ETF	140.23	140.26	139.64	139.66	82581.0
2018-12-17 09:00:00	IWM	ETF	139.67	139.9685	138.11	139.15	3105603.0
2018-12-17 10:00:00	IWM	ETF	139.13	140.32	138.81	140.05	4782169.0
2018-12-17 11:00:00	IWM	ETF	140.07	140.8801	140.05	140.74	3350331.0
2018-12-17 12:00:00	IWM	ETF	140.74	140.86	138.3804	138.3804	3051935.0
2018-12-17 13:00:00	IWM	ETF	138.38	139.0	138.1	138.29	3298570.0
2018-12-17 14:00:00	IWM	ETF	138.23	138.42	137.68	137.82	3324924.0
2018-12-17 15:00:00	IWM	ETF	137.82	137.96	136.16	136.98	9237465.0
2018-12-17 16:00:00	IWM	ETF	136.98	137.81	136.8363	137.7	1804473.0
2018-12-17 17:00:00	IWM	ETF	137.79	137.79	137.02	137.74	532901.0
2018-12-17 18:00:00	IWM	ETF	137.69	138.0	137.02	137.99	10187.0
2018-12-17 19:00:00	IWM	ETF	137.8	137.91	137.72	137.86	3093.0
2018-12-17 04:00:00	DIA	ETF	241.71	241.75	241.62	241.62	700.0
2018-12-17 05:00:00	DIA	ETF	241.7	241.7	241.7	241.7	100.0

> showing 50 of 11,053 rows — these rows as CSV

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