PREVIEW / etf_1hour / 2018-04-06

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-06.parquet
  size:    299 KB
  rows:    9,794

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-04-06 04:00:00	SPY	ETF	263.23	263.71	263.23	263.63	25640.0
2018-04-06 05:00:00	SPY	ETF	263.65	263.96	263.39	263.91	42752.0
2018-04-06 06:00:00	SPY	ETF	263.88	264.33	263.84	263.95	92463.0
2018-04-06 07:00:00	SPY	ETF	263.96	264.02	262.88	262.91	390726.0
2018-04-06 08:00:00	SPY	ETF	263.46	265.64	262.3	263.78	2177898.0
2018-04-06 09:00:00	SPY	ETF	263.76	265.64	263.11	264.61	12027718.0
2018-04-06 10:00:00	SPY	ETF	264.62	264.88	262.62	262.89	15809711.0
2018-04-06 11:00:00	SPY	ETF	262.9	263.26	262.03	263.0884	13700725.0
2018-04-06 12:00:00	SPY	ETF	263.06	263.41	261.7	263.37	11141203.0
2018-04-06 13:00:00	SPY	ETF	263.35	263.35	260.36	260.395	15300768.0
2018-04-06 14:00:00	SPY	ETF	260.39	260.65	258.1	258.46	29094810.0
2018-04-06 15:00:00	SPY	ETF	258.47	260.69	258.0	259.8	48001123.0
2018-04-06 16:00:00	SPY	ETF	259.78	262.4	259.71	260.01	27186518.0
2018-04-06 17:00:00	SPY	ETF	260.02	260.07	259.61	259.64	920291.0
2018-04-06 18:00:00	SPY	ETF	259.64	259.64	259.45	259.47	61124.0
2018-04-06 19:00:00	SPY	ETF	259.54	259.54	259.45	259.46	17272.0
2018-04-06 04:00:00	QQQ	ETF	159.0	159.32	158.98	159.26	9783.0
2018-04-06 05:00:00	QQQ	ETF	159.18	159.48	158.98	159.41	13996.0
2018-04-06 06:00:00	QQQ	ETF	159.55	159.7	159.35	159.39	27266.0
2018-04-06 07:00:00	QQQ	ETF	159.45	159.45	158.45	158.48	128594.0
2018-04-06 08:00:00	QQQ	ETF	158.52	159.6	158.47	159.18	684705.0
2018-04-06 09:00:00	QQQ	ETF	159.2	160.4601	158.62	160.1	5893296.0
2018-04-06 10:00:00	QQQ	ETF	160.11	160.27	158.57	158.979	5306280.0
2018-04-06 11:00:00	QQQ	ETF	158.95	159.579	158.36	159.43	4424724.0
2018-04-06 12:00:00	QQQ	ETF	159.43	159.4948	158.39	159.43	4217716.0
2018-04-06 13:00:00	QQQ	ETF	159.43	159.43	157.2675	157.285	6735915.0
2018-04-06 14:00:00	QQQ	ETF	157.27	157.55	155.95	156.25	9265280.0
2018-04-06 15:00:00	QQQ	ETF	156.26	157.43	155.88	156.68	14372228.0
2018-04-06 16:00:00	QQQ	ETF	156.69	159.9897	156.61	157.03	4031797.0
2018-04-06 17:00:00	QQQ	ETF	156.96	156.96	156.62	156.67	56696.0
2018-04-06 18:00:00	QQQ	ETF	156.62	156.67	156.55	156.58	5723.0
2018-04-06 19:00:00	QQQ	ETF	156.62	156.68	156.57	156.57	5465.0
2018-04-06 04:00:00	IWM	ETF	152.49	152.68	152.36	152.68	900.0
2018-04-06 05:00:00	IWM	ETF	152.53	152.77	152.5	152.76	11100.0
2018-04-06 06:00:00	IWM	ETF	152.76	152.76	152.66	152.71	8766.0
2018-04-06 07:00:00	IWM	ETF	152.67	152.67	152.27	152.3	10200.0
2018-04-06 08:00:00	IWM	ETF	153.42	153.42	152.22	152.75	198164.0
2018-04-06 09:00:00	IWM	ETF	152.65	153.4	152.19	152.8	2300383.0
2018-04-06 10:00:00	IWM	ETF	152.81	153.0199	151.995	152.08	2501586.0
2018-04-06 11:00:00	IWM	ETF	152.07	152.2	151.4	152.0725	1811327.0
2018-04-06 12:00:00	IWM	ETF	152.08	152.16	151.32	151.98	1510577.0
2018-04-06 13:00:00	IWM	ETF	151.96	151.96	150.38	150.41	1783168.0
2018-04-06 14:00:00	IWM	ETF	150.4099	150.6	149.29	149.5	3309682.0
2018-04-06 15:00:00	IWM	ETF	149.5	150.82	149.15	150.41	6808790.0
2018-04-06 16:00:00	IWM	ETF	150.36	150.62	150.15	150.61	2547425.0
2018-04-06 17:00:00	IWM	ETF	150.42	150.44	150.36	150.39	980059.0
2018-04-06 18:00:00	IWM	ETF	150.36	150.4	150.3	150.32	5477.0
2018-04-06 06:00:00	DIA	ETF	242.8	243.25	242.8	243.02	7948.0
2018-04-06 07:00:00	DIA	ETF	243.12	243.12	242.17	242.17	12968.0
2018-04-06 08:00:00	DIA	ETF	242.92	243.24	242.2	242.87	32244.0

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

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