PREVIEW / etf_1hour / 2010-04-15

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-15.parquet
  size:    158 KB
  rows:    4,918

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
2010-04-15 04:00:00	SPY	ETF	120.94	120.94	120.87	120.87	5640.0
2010-04-15 05:00:00	SPY	ETF	120.76	120.76	120.65	120.73	51540.0
2010-04-15 06:00:00	SPY	ETF	120.81	121.0	120.81	120.9	17500.0
2010-04-15 07:00:00	SPY	ETF	120.89	120.92	120.83	120.91	359301.0
2010-04-15 08:00:00	SPY	ETF	120.9	121.15	120.74	120.91	2161822.0
2010-04-15 09:00:00	SPY	ETF	120.92	121.12	120.85	121.05	14878206.0
2010-04-15 10:00:00	SPY	ETF	121.05	121.482	120.96	121.47	24564799.0
2010-04-15 11:00:00	SPY	ETF	121.47	121.5654	121.01	121.09	24700794.0
2010-04-15 12:00:00	SPY	ETF	121.09	121.22	120.95	121.2	15511520.0
2010-04-15 13:00:00	SPY	ETF	121.2	121.45	121.15	121.36	13834440.0
2010-04-15 14:00:00	SPY	ETF	121.36	121.51	121.33	121.49	12056159.0
2010-04-15 15:00:00	SPY	ETF	121.49	121.49	121.1	121.31	27168468.0
2010-04-15 16:00:00	SPY	ETF	121.3	121.35	120.8961	121.11	8110070.0
2010-04-15 17:00:00	SPY	ETF	121.11	121.15	121.03	121.05	191074.0
2010-04-15 18:00:00	SPY	ETF	121.06	121.14	121.05	121.12	81092.0
2010-04-15 19:00:00	SPY	ETF	121.11	121.12	121.0	121.01	31137.0
2010-04-15 04:00:00	QQQ	ETF	49.81	49.81	49.81	49.81	200.0
2010-04-15 05:00:00	QQQ	ETF	49.73	49.73	49.73	49.73	250.0
2010-04-15 06:00:00	QQQ	ETF	49.79	49.79	49.79	49.79	12000.0
2010-04-15 07:00:00	QQQ	ETF	49.8	49.82	49.77	49.78	89595.0
2010-04-15 08:00:00	QQQ	ETF	49.79	49.86	49.73	49.84	939018.0
2010-04-15 09:00:00	QQQ	ETF	49.85	50.0	49.81	49.96	10029406.0
2010-04-15 10:00:00	QQQ	ETF	49.96	50.15	49.9	50.13	12029613.0
2010-04-15 11:00:00	QQQ	ETF	50.13	50.19	49.98	50.02	9464018.0
2010-04-15 12:00:00	QQQ	ETF	50.02	50.09	49.98	50.07	6366182.0
2010-04-15 13:00:00	QQQ	ETF	50.07	50.15	50.04	50.1062	5548139.0
2010-04-15 14:00:00	QQQ	ETF	50.1062	50.18	50.06	50.1787	4159910.0
2010-04-15 15:00:00	QQQ	ETF	50.1767	50.18	50.06	50.13	12411087.0
2010-04-15 16:00:00	QQQ	ETF	50.13	50.14	49.87	49.97	8051422.0
2010-04-15 17:00:00	QQQ	ETF	49.97	50.02	49.92	49.92	186913.0
2010-04-15 18:00:00	QQQ	ETF	49.95	49.98	49.94	49.98	82822.0
2010-04-15 19:00:00	QQQ	ETF	49.98	50.0	49.95	49.97	24271.0
2010-04-15 07:00:00	IWM	ETF	72.1	72.1	72.04	72.1	76299.0
2010-04-15 08:00:00	IWM	ETF	71.82	72.18	71.82	72.09	1005773.0
2010-04-15 09:00:00	IWM	ETF	72.1	72.25	72.04	72.2	6370606.0
2010-04-15 10:00:00	IWM	ETF	72.2	72.58	72.14	72.5	11557519.0
2010-04-15 11:00:00	IWM	ETF	72.5	72.54	72.11	72.14	6532567.0
2010-04-15 12:00:00	IWM	ETF	72.14	72.36	72.09	72.35	4281868.0
2010-04-15 13:00:00	IWM	ETF	72.35	72.48	72.31	72.389	3758455.0
2010-04-15 14:00:00	IWM	ETF	72.39	72.56	72.25	72.55	3737975.0
2010-04-15 15:00:00	IWM	ETF	72.55	72.57	72.2	72.43	11251939.0
2010-04-15 16:00:00	IWM	ETF	72.43	72.49	72.2366	72.27	6275796.0
2010-04-15 17:00:00	IWM	ETF	72.27	72.36	72.27	72.29	124778.0
2010-04-15 18:00:00	IWM	ETF	72.29	72.31	72.26	72.26	4749.0
2010-04-15 19:00:00	IWM	ETF	72.26	72.29	72.26	72.26	2727.0
2010-04-15 06:00:00	DIA	ETF	111.11	111.11	111.09	111.11	4100.0
2010-04-15 07:00:00	DIA	ETF	111.07	111.1	111.03	111.1	21500.0
2010-04-15 08:00:00	DIA	ETF	111.12	111.17	110.99	111.11	58170.0
2010-04-15 09:00:00	DIA	ETF	111.08	111.21	111.01	111.1	2062447.0
2010-04-15 10:00:00	DIA	ETF	111.1	111.42	111.04	111.39	1231851.0

> showing 50 of 4,918 rows — these rows as CSV

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