PREVIEW / etf_1hour / 2010-12-09

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-09.parquet
  size:    171 KB
  rows:    5,253

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-12-09 04:00:00	SPY	ETF	123.86	124.04	123.7	123.7	10800.0
2010-12-09 05:00:00	SPY	ETF	123.63	123.79	123.58	123.69	3200.0
2010-12-09 06:00:00	SPY	ETF	123.71	123.77	123.69	123.75	78300.0
2010-12-09 07:00:00	SPY	ETF	123.76	123.84	123.73	123.77	147761.0
2010-12-09 08:00:00	SPY	ETF	123.77	124.09	123.72	123.97	2102046.0
2010-12-09 09:00:00	SPY	ETF	123.97	124.05	123.62	123.87	19071054.0
2010-12-09 10:00:00	SPY	ETF	123.87	123.94	123.25	123.38	19810753.0
2010-12-09 11:00:00	SPY	ETF	123.37	123.6	123.15	123.37	15669079.0
2010-12-09 12:00:00	SPY	ETF	123.37	123.52	123.33	123.46	8680783.0
2010-12-09 13:00:00	SPY	ETF	123.47	123.73	123.42	123.6	13936166.0
2010-12-09 14:00:00	SPY	ETF	123.61	123.62	123.37	123.57	9771532.0
2010-12-09 15:00:00	SPY	ETF	123.57	123.88	123.51	123.79	24707141.0
2010-12-09 16:00:00	SPY	ETF	123.79	123.9776	123.3168	123.73	7589795.0
2010-12-09 17:00:00	SPY	ETF	123.74	123.76	123.7	123.73	91240.0
2010-12-09 18:00:00	SPY	ETF	123.73	124.07	123.73	124.01	375919.0
2010-12-09 19:00:00	SPY	ETF	124.02	124.06	123.82	123.9	199496.0
2010-12-09 05:00:00	QQQ	ETF	54.27	54.27	54.21	54.21	2000.0
2010-12-09 07:00:00	QQQ	ETF	54.24	54.29	54.23	54.26	102059.0
2010-12-09 08:00:00	QQQ	ETF	54.26	54.39	54.24	54.37	480034.0
2010-12-09 09:00:00	QQQ	ETF	54.37	54.44	54.19	54.3099	8904821.0
2010-12-09 10:00:00	QQQ	ETF	54.3	54.33	53.98	54.05	8751427.0
2010-12-09 11:00:00	QQQ	ETF	54.048	54.15	53.95	54.06	7244101.0
2010-12-09 12:00:00	QQQ	ETF	54.06	54.15	54.04	54.12	1352529.0
2010-12-09 13:00:00	QQQ	ETF	54.12	54.2	54.09	54.17	3801890.0
2010-12-09 14:00:00	QQQ	ETF	54.16	54.17	54.02	54.09	3283076.0
2010-12-09 15:00:00	QQQ	ETF	54.09	54.22	54.061	54.15	7695789.0
2010-12-09 16:00:00	QQQ	ETF	54.15	54.2001	54.04	54.07	4842656.0
2010-12-09 17:00:00	QQQ	ETF	54.07	54.08	54.06	54.06	27287.0
2010-12-09 18:00:00	QQQ	ETF	54.08	54.2	54.08	54.2	143806.0
2010-12-09 19:00:00	QQQ	ETF	54.15	54.17	54.12	54.17	55540.0
2010-12-09 06:00:00	IWM	ETF	77.04	77.04	77.02	77.03	10000.0
2010-12-09 07:00:00	IWM	ETF	77.0	77.02	76.94	76.96	55994.0
2010-12-09 08:00:00	IWM	ETF	76.97	77.18	76.91	77.08	1066593.0
2010-12-09 09:00:00	IWM	ETF	77.09	77.16	76.74	76.885	4627204.0
2010-12-09 10:00:00	IWM	ETF	76.88	76.91	76.48	76.5	6762565.0
2010-12-09 11:00:00	IWM	ETF	76.5	76.81	76.49	76.65	6061467.0
2010-12-09 12:00:00	IWM	ETF	76.648	76.79	76.64	76.78	2279099.0
2010-12-09 13:00:00	IWM	ETF	76.77	77.01	76.76	76.95	3695670.0
2010-12-09 14:00:00	IWM	ETF	76.959	76.97	76.82	76.91	3208009.0
2010-12-09 15:00:00	IWM	ETF	76.92	77.04	76.78	76.8	7669207.0
2010-12-09 16:00:00	IWM	ETF	76.8	76.9022	76.74	76.79	2309271.0
2010-12-09 17:00:00	IWM	ETF	76.8	76.82	76.79	76.82	11413.0
2010-12-09 18:00:00	IWM	ETF	76.84	76.91	76.84	76.91	2100.0
2010-12-09 19:00:00	IWM	ETF	76.9	76.92	76.88	76.9	6300.0
2010-12-09 07:00:00	DIA	ETF	114.22	114.29	114.2	114.29	700.0
2010-12-09 08:00:00	DIA	ETF	114.19	114.44	114.19	114.37	13380.0
2010-12-09 09:00:00	DIA	ETF	114.39	114.43	113.95	114.07	1128674.0
2010-12-09 10:00:00	DIA	ETF	114.07	114.11	113.59	113.6699	877395.0
2010-12-09 11:00:00	DIA	ETF	113.67	113.78	113.51	113.64	728517.0
2010-12-09 12:00:00	DIA	ETF	113.6499	113.7	113.59	113.65	324941.0

> showing 50 of 5,253 rows — these rows as CSV

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