PREVIEW / etf_1hour / 2010-12-23

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-12-23.parquet
  size:    161 KB
  rows:    5,059

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-23 04:00:00	SPY	ETF	125.71	125.71	125.71	125.71	100.0
2010-12-23 07:00:00	SPY	ETF	125.73	125.78	125.67	125.7	96596.0
2010-12-23 08:00:00	SPY	ETF	125.71	125.73	125.52	125.65	918622.0
2010-12-23 09:00:00	SPY	ETF	125.65	125.78	125.59	125.72	8624474.0
2010-12-23 10:00:00	SPY	ETF	125.72	125.76	125.49	125.59	12970929.0
2010-12-23 11:00:00	SPY	ETF	125.595	125.72	125.56	125.6	9099950.0
2010-12-23 12:00:00	SPY	ETF	125.61	125.64	125.52	125.56	4689489.0
2010-12-23 13:00:00	SPY	ETF	125.56	125.65	125.53	125.53	4691129.0
2010-12-23 14:00:00	SPY	ETF	125.53	125.57	125.29	125.46	10696936.0
2010-12-23 15:00:00	SPY	ETF	125.47	125.61	125.42	125.59	11740389.0
2010-12-23 16:00:00	SPY	ETF	125.59	125.765	125.325	125.67	4199459.0
2010-12-23 17:00:00	SPY	ETF	125.67	125.68	125.62	125.66	34110.0
2010-12-23 18:00:00	SPY	ETF	125.64	125.66	125.63	125.66	17625.0
2010-12-23 19:00:00	SPY	ETF	125.66	125.66	125.61	125.65	9493.0
2010-12-23 04:00:00	QQQ	ETF	54.9	54.9	54.9	54.9	200.0
2010-12-23 05:00:00	QQQ	ETF	54.92	54.92	54.92	54.92	200.0
2010-12-23 07:00:00	QQQ	ETF	54.81	54.85	54.81	54.83	20675.0
2010-12-23 08:00:00	QQQ	ETF	54.82	54.84	54.72	54.79	373990.0
2010-12-23 09:00:00	QQQ	ETF	54.79	54.87	54.75	54.8	2928245.0
2010-12-23 10:00:00	QQQ	ETF	54.8	54.84	54.61	54.67	4033771.0
2010-12-23 11:00:00	QQQ	ETF	54.67	54.76	54.67	54.709	3549262.0
2010-12-23 12:00:00	QQQ	ETF	54.7	54.73	54.6425	54.705	1702745.0
2010-12-23 13:00:00	QQQ	ETF	54.7095	54.76	54.7095	54.71	1625792.0
2010-12-23 14:00:00	QQQ	ETF	54.7022	54.72	54.64	54.69	2425067.0
2010-12-23 15:00:00	QQQ	ETF	54.6899	54.76	54.67	54.75	3911714.0
2010-12-23 16:00:00	QQQ	ETF	54.74	54.83	54.74	54.745	563577.0
2010-12-23 17:00:00	QQQ	ETF	54.77	54.78	54.75	54.75	15760.0
2010-12-23 18:00:00	QQQ	ETF	54.76	54.76	54.76	54.76	1900.0
2010-12-23 19:00:00	QQQ	ETF	54.77	54.78	54.76	54.77	2450.0
2010-12-23 07:00:00	IWM	ETF	78.84	79.03	78.84	79.01	175400.0
2010-12-23 08:00:00	IWM	ETF	79.01	79.01	78.87	78.94	475896.0
2010-12-23 09:00:00	IWM	ETF	78.94	79.12	78.87	78.965	3520557.0
2010-12-23 10:00:00	IWM	ETF	78.96	79.03	78.748	78.88	4204383.0
2010-12-23 11:00:00	IWM	ETF	78.88	79.06	78.88	78.9701	2549207.0
2010-12-23 12:00:00	IWM	ETF	78.975	78.98	78.75	78.85	2082819.0
2010-12-23 13:00:00	IWM	ETF	78.84	78.92	78.78	78.8	1315481.0
2010-12-23 14:00:00	IWM	ETF	78.8	78.831	78.61	78.74	2712255.0
2010-12-23 15:00:00	IWM	ETF	78.74	78.9	78.64	78.75	7045040.0
2010-12-23 16:00:00	IWM	ETF	78.75	78.81	78.7014	78.8	518034.0
2010-12-23 17:00:00	IWM	ETF	78.78	78.78	78.72	78.78	1300.0
2010-12-23 18:00:00	IWM	ETF	78.78	78.78	78.78	78.78	300.0
2010-12-23 19:00:00	IWM	ETF	78.8	78.8	78.75	78.8	1600.0
2010-12-23 08:00:00	DIA	ETF	115.48	115.48	115.41	115.45	2200.0
2010-12-23 09:00:00	DIA	ETF	115.49	115.72	115.48	115.68	356835.0
2010-12-23 10:00:00	DIA	ETF	115.68	115.739	115.6	115.68	504121.0
2010-12-23 11:00:00	DIA	ETF	115.68	115.79	115.63	115.6503	1234078.0
2010-12-23 12:00:00	DIA	ETF	115.6502	115.679	115.59	115.63	310057.0
2010-12-23 13:00:00	DIA	ETF	115.63	115.7	115.62	115.65	205194.0
2010-12-23 14:00:00	DIA	ETF	115.64	115.68	115.4	115.56	361520.0
2010-12-23 15:00:00	DIA	ETF	115.5664	115.74	115.52	115.73	572933.0

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

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