PREVIEW / etf_1hour / 2018-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-29.parquet
  size:    297 KB
  rows:    9,685

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-03-29 04:00:00	SPY	ETF	260.63	260.84	260.23	260.84	6885.0
2018-03-29 05:00:00	SPY	ETF	260.82	261.3	260.57	261.28	19558.0
2018-03-29 06:00:00	SPY	ETF	261.18	261.23	260.97	260.97	55600.0
2018-03-29 07:00:00	SPY	ETF	261.04	261.39	260.94	261.25	136985.0
2018-03-29 08:00:00	SPY	ETF	261.07	261.25	259.49	261.06	932168.0
2018-03-29 09:00:00	SPY	ETF	261.05	261.72	260.28	260.55	10526923.0
2018-03-29 10:00:00	SPY	ETF	260.54	262.75	260.39	262.74	13802921.0
2018-03-29 11:00:00	SPY	ETF	262.73	263.49	262.13	262.88	12173815.0
2018-03-29 12:00:00	SPY	ETF	262.88	263.0	262.01	262.75	7606738.0
2018-03-29 13:00:00	SPY	ETF	262.75	263.86	262.23	263.57	7203855.0
2018-03-29 14:00:00	SPY	ETF	263.565	264.84	263.25	264.4	15078657.0
2018-03-29 15:00:00	SPY	ETF	264.4	265.26	263.4	263.49	31924861.0
2018-03-29 16:00:00	SPY	ETF	263.5	264.1455	262.79	262.97	18981285.0
2018-03-29 17:00:00	SPY	ETF	262.99	263.15	262.8	262.97	790483.0
2018-03-29 18:00:00	SPY	ETF	263.0	263.05	262.39	262.67	252180.0
2018-03-29 19:00:00	SPY	ETF	262.67	262.79	262.6	262.65	38211.0
2018-03-29 04:00:00	QQQ	ETF	158.21	158.39	157.99	158.39	25437.0
2018-03-29 05:00:00	QQQ	ETF	158.35	158.85	158.14	158.78	14550.0
2018-03-29 06:00:00	QQQ	ETF	158.79	158.79	158.32	158.34	28039.0
2018-03-29 07:00:00	QQQ	ETF	158.34	158.93	158.34	158.71	296255.0
2018-03-29 08:00:00	QQQ	ETF	158.67	158.74	158.02	158.41	616587.0
2018-03-29 09:00:00	QQQ	ETF	158.35	158.59	156.6338	156.95	7468213.0
2018-03-29 10:00:00	QQQ	ETF	156.97	159.57	156.8	159.57	9105081.0
2018-03-29 11:00:00	QQQ	ETF	159.56	159.88	158.66	159.255	8377869.0
2018-03-29 12:00:00	QQQ	ETF	159.26	159.6301	158.49	159.46	3802278.0
2018-03-29 13:00:00	QQQ	ETF	159.46	160.82	158.84	160.56	4313567.0
2018-03-29 14:00:00	QQQ	ETF	160.56	161.505	160.22	161.22	6600020.0
2018-03-29 15:00:00	QQQ	ETF	161.21	161.71	160.11	160.17	13196172.0
2018-03-29 16:00:00	QQQ	ETF	160.2	160.501	158.2624	159.72	3062984.0
2018-03-29 17:00:00	QQQ	ETF	159.75	160.13	159.65	159.75	964528.0
2018-03-29 18:00:00	QQQ	ETF	159.75	159.78	159.65	159.69	22925.0
2018-03-29 19:00:00	QQQ	ETF	159.7	159.71	159.63	159.7	26143.0
2018-03-29 04:00:00	IWM	ETF	150.73	150.74	150.62	150.63	6184.0
2018-03-29 05:00:00	IWM	ETF	150.96	151.23	150.86	151.23	11485.0
2018-03-29 06:00:00	IWM	ETF	151.24	151.28	151.09	151.09	9875.0
2018-03-29 07:00:00	IWM	ETF	151.09	151.32	151.04	151.24	13755.0
2018-03-29 08:00:00	IWM	ETF	151.3	151.3	150.96	151.14	160524.0
2018-03-29 09:00:00	IWM	ETF	151.1	151.47	150.84	151.06	2753156.0
2018-03-29 10:00:00	IWM	ETF	151.07	152.31	150.75	152.3	3229281.0
2018-03-29 11:00:00	IWM	ETF	152.29	152.44	151.57	152.04	2609330.0
2018-03-29 12:00:00	IWM	ETF	152.05	152.31	151.64	152.21	1273202.0
2018-03-29 13:00:00	IWM	ETF	152.21	152.74	151.96	152.57	1034094.0
2018-03-29 14:00:00	IWM	ETF	152.57	153.1	152.45	152.71	1572327.0
2018-03-29 15:00:00	IWM	ETF	152.71	153.045	151.84	151.8475	5652584.0
2018-03-29 16:00:00	IWM	ETF	151.87	152.0421	151.25	151.56	1899978.0
2018-03-29 17:00:00	IWM	ETF	151.83	151.83	151.83	151.83	477500.0
2018-03-29 18:00:00	IWM	ETF	151.61	151.83	151.6	151.69	2139.0
2018-03-29 19:00:00	IWM	ETF	151.69	151.69	151.67	151.69	2066.0
2018-03-29 05:00:00	DIA	ETF	239.34	239.34	239.34	239.34	500.0
2018-03-29 06:00:00	DIA	ETF	239.5	239.5	239.5	239.5	500.0

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

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