PREVIEW / etf_1hour / 2019-02-28

all etf 1-hour files

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

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-28 04:00:00	SPY	ETF	278.66	278.83	278.66	278.77	7719.0
2019-02-28 05:00:00	SPY	ETF	278.75	278.8	278.61	278.75	15001.0
2019-02-28 06:00:00	SPY	ETF	278.74	278.86	278.65	278.86	18497.0
2019-02-28 07:00:00	SPY	ETF	278.87	279.15	278.71	279.01	202205.0
2019-02-28 08:00:00	SPY	ETF	278.85	279.3	278.3	279.07	339072.0
2019-02-28 09:00:00	SPY	ETF	279.06	279.35	278.73	279.1	5565911.0
2019-02-28 10:00:00	SPY	ETF	279.1	279.1	278.4	278.71	8283005.0
2019-02-28 11:00:00	SPY	ETF	278.71	279.29	278.42	279.078	5103014.0
2019-02-28 12:00:00	SPY	ETF	279.08	279.45	279.0	279.41	3197435.0
2019-02-28 13:00:00	SPY	ETF	279.41	279.44	279.02	279.1557	3466917.0
2019-02-28 14:00:00	SPY	ETF	279.155	279.275	278.67	278.845	5641472.0
2019-02-28 15:00:00	SPY	ETF	278.8426	279.19	278.32	278.54	21837859.0
2019-02-28 16:00:00	SPY	ETF	278.54	279.04	278.46	278.74	12582001.0
2019-02-28 17:00:00	SPY	ETF	278.76	278.77	278.5289	278.63	425257.0
2019-02-28 18:00:00	SPY	ETF	278.62	278.66	278.34	278.59	86803.0
2019-02-28 19:00:00	SPY	ETF	278.57	278.82	278.56	278.8	62425.0
2019-02-28 04:00:00	QQQ	ETF	172.9	172.9	172.78	172.86	24888.0
2019-02-28 05:00:00	QQQ	ETF	172.75	172.85	172.72	172.82	41330.0
2019-02-28 06:00:00	QQQ	ETF	172.81	172.95	172.8	172.89	23056.0
2019-02-28 07:00:00	QQQ	ETF	172.91	173.1	172.82	173.03	101510.0
2019-02-28 08:00:00	QQQ	ETF	172.9101	173.29	172.85	173.09	223926.0
2019-02-28 09:00:00	QQQ	ETF	173.08	173.595	172.91	173.35	2602871.0
2019-02-28 10:00:00	QQQ	ETF	173.34	173.34	172.7	173.08	4301869.0
2019-02-28 11:00:00	QQQ	ETF	173.08	173.68	172.88	173.52	2553875.0
2019-02-28 12:00:00	QQQ	ETF	173.53	173.81	173.42	173.75	1573259.0
2019-02-28 13:00:00	QQQ	ETF	173.76	173.79	173.49	173.5899	1457748.0
2019-02-28 14:00:00	QQQ	ETF	173.58	173.67	173.26	173.38	1666654.0
2019-02-28 15:00:00	QQQ	ETF	173.38	173.52	172.9	173.17	6260898.0
2019-02-28 16:00:00	QQQ	ETF	173.17	173.45	173.1188	173.3	1157580.0
2019-02-28 17:00:00	QQQ	ETF	173.31	173.39	173.25	173.29	39894.0
2019-02-28 18:00:00	QQQ	ETF	173.28	173.28	173.04	173.19	365149.0
2019-02-28 19:00:00	QQQ	ETF	173.26	173.4	173.26	173.37	23872.0
2019-02-28 05:00:00	IWM	ETF	156.95	156.97	156.92	156.97	3500.0
2019-02-28 06:00:00	IWM	ETF	156.97	156.99	156.94	156.99	18000.0
2019-02-28 07:00:00	IWM	ETF	157.0	157.22	156.95	157.18	16700.0
2019-02-28 08:00:00	IWM	ETF	157.12	157.22	157.02	157.15	21143.0
2019-02-28 09:00:00	IWM	ETF	157.12	157.15	156.52	156.555	1782717.0
2019-02-28 10:00:00	IWM	ETF	156.55	156.953	156.37	156.805	3757734.0
2019-02-28 11:00:00	IWM	ETF	156.81	157.34	156.58	157.14	1541442.0
2019-02-28 12:00:00	IWM	ETF	157.15	157.4	157.03	157.31	923133.0
2019-02-28 13:00:00	IWM	ETF	157.31	157.48	157.25	157.37	763710.0
2019-02-28 14:00:00	IWM	ETF	157.37	157.41	156.91	157.025	1340435.0
2019-02-28 15:00:00	IWM	ETF	157.025	157.23	156.7	156.72	4277840.0
2019-02-28 16:00:00	IWM	ETF	156.7	157.03	156.7	156.92	1622785.0
2019-02-28 17:00:00	IWM	ETF	156.89	156.9	156.83	156.83	3275.0
2019-02-28 18:00:00	IWM	ETF	156.84	156.87	156.75	156.85	113200.0
2019-02-28 19:00:00	IWM	ETF	156.85	156.95	156.83	156.95	9700.0
2019-02-28 05:00:00	DIA	ETF	259.59	259.59	259.5	259.5	300.0
2019-02-28 07:00:00	DIA	ETF	259.62	260.0	259.62	259.89	800.0
2019-02-28 08:00:00	DIA	ETF	259.67	260.23	259.25	259.91	16438.0

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

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