PREVIEW / etf_1hour / 2015-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-04-01.parquet
  size:    243 KB
  rows:    7,750

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
2015-04-01 04:00:00	SPY	ETF	205.78	205.79	205.6	205.78	7117.0
2015-04-01 05:00:00	SPY	ETF	205.94	206.52	205.94	206.47	18085.0
2015-04-01 06:00:00	SPY	ETF	206.48	206.54	206.35	206.4	135137.0
2015-04-01 07:00:00	SPY	ETF	206.4	206.41	205.65	205.83	617647.0
2015-04-01 08:00:00	SPY	ETF	205.81	206.43	204.82	205.979	1489482.0
2015-04-01 09:00:00	SPY	ETF	205.98	206.43	204.51	204.84	26200495.0
2015-04-01 10:00:00	SPY	ETF	204.83	205.93	204.67	205.7	25333190.0
2015-04-01 11:00:00	SPY	ETF	205.69	206.02	205.34	205.47	12836077.0
2015-04-01 12:00:00	SPY	ETF	205.48	205.71	205.06	205.49	9990915.0
2015-04-01 13:00:00	SPY	ETF	205.5	205.95	205.29	205.74	9866243.0
2015-04-01 14:00:00	SPY	ETF	205.75	205.8	205.1	205.42	12923563.0
2015-04-01 15:00:00	SPY	ETF	205.42	205.76	205.03	205.76	24411884.0
2015-04-01 16:00:00	SPY	ETF	205.76	206.06	205.2559	205.93	7782983.0
2015-04-01 17:00:00	SPY	ETF	205.91	206.05	205.89	206.04	1136289.0
2015-04-01 18:00:00	SPY	ETF	206.05	206.23	205.7	205.97	144366.0
2015-04-01 19:00:00	SPY	ETF	205.97	206.04	205.74	205.79	81719.0
2015-04-01 04:00:00	QQQ	ETF	105.25	105.34	105.17	105.34	30740.0
2015-04-01 05:00:00	QQQ	ETF	105.53	105.81	105.53	105.78	8000.0
2015-04-01 06:00:00	QQQ	ETF	105.67	105.68	105.63	105.66	19500.0
2015-04-01 07:00:00	QQQ	ETF	105.62	105.62	105.24	105.29	109799.0
2015-04-01 08:00:00	QQQ	ETF	105.33	105.6	105.24	105.46	227815.0
2015-04-01 09:00:00	QQQ	ETF	105.45	105.62	104.37	104.5001	7166815.0
2015-04-01 10:00:00	QQQ	ETF	104.49	104.98	104.37	104.87	7427321.0
2015-04-01 11:00:00	QQQ	ETF	104.87	105.1	104.71	104.8059	2426936.0
2015-04-01 12:00:00	QQQ	ETF	104.81	104.9	104.611	104.72	1945072.0
2015-04-01 13:00:00	QQQ	ETF	104.72	105.05	104.63	104.92	1803768.0
2015-04-01 14:00:00	QQQ	ETF	104.93	104.97	104.54	104.755	2181746.0
2015-04-01 15:00:00	QQQ	ETF	104.7599	105.06	104.56	105.05	5254921.0
2015-04-01 16:00:00	QQQ	ETF	105.06	105.5795	104.6296	105.28	2105319.0
2015-04-01 17:00:00	QQQ	ETF	105.29	105.35	105.07	105.25	16116.0
2015-04-01 18:00:00	QQQ	ETF	105.35	105.4	105.3	105.3	51079.0
2015-04-01 19:00:00	QQQ	ETF	105.3	105.35	105.17	105.2	11767.0
2015-04-01 07:00:00	IWM	ETF	124.01	124.04	123.93	123.99	35000.0
2015-04-01 08:00:00	IWM	ETF	123.99	124.35	123.86	123.95	67636.0
2015-04-01 09:00:00	IWM	ETF	124.35	124.35	122.9	123.18	4965649.0
2015-04-01 10:00:00	IWM	ETF	123.17	124.29	123.03	124.13	5282826.0
2015-04-01 11:00:00	IWM	ETF	124.13	124.37	123.92	123.94	2409186.0
2015-04-01 12:00:00	IWM	ETF	123.93	124.0145	123.255	123.5585	2647833.0
2015-04-01 13:00:00	IWM	ETF	123.55	124.1299	123.45	123.96	1654246.0
2015-04-01 14:00:00	IWM	ETF	123.96	124.03	123.52	123.795	2473903.0
2015-04-01 15:00:00	IWM	ETF	123.809	124.38	123.56	124.38	7318375.0
2015-04-01 16:00:00	IWM	ETF	124.38	124.59	123.807	124.38	2343043.0
2015-04-01 17:00:00	IWM	ETF	124.4	124.46	124.37	124.46	20722.0
2015-04-01 18:00:00	IWM	ETF	124.49	124.54	124.49	124.54	1260.0
2015-04-01 19:00:00	IWM	ETF	124.43	124.43	124.07	124.09	33206.0
2015-04-01 07:00:00	DIA	ETF	177.16	177.16	176.98	177.03	6100.0
2015-04-01 08:00:00	DIA	ETF	177.23	177.23	176.95	177.01	9960.0
2015-04-01 09:00:00	DIA	ETF	177.16	177.54	175.57	175.8303	1331523.0
2015-04-01 10:00:00	DIA	ETF	175.83	176.83	175.68	176.69	1729444.0
2015-04-01 11:00:00	DIA	ETF	176.76	176.95	176.36	176.49	773397.0

> showing 50 of 7,750 rows — these rows as CSV

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