PREVIEW / etf_1hour / 2010-04-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-08.parquet
  size:    157 KB
  rows:    4,835

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-08 04:00:00	SPY	ETF	117.89	117.9	117.77	117.9	5400.0
2010-04-08 05:00:00	SPY	ETF	117.85	117.9	117.8	117.9	8050.0
2010-04-08 06:00:00	SPY	ETF	117.87	118.02	117.85	118.0	13600.0
2010-04-08 07:00:00	SPY	ETF	118.01	118.04	117.74	117.78	675234.0
2010-04-08 08:00:00	SPY	ETF	117.78	118.0	117.69	117.97	3436034.0
2010-04-08 09:00:00	SPY	ETF	117.98	118.02	117.6	117.7299	25576559.0
2010-04-08 10:00:00	SPY	ETF	117.72	118.1117	117.64	118.01	22317153.0
2010-04-08 11:00:00	SPY	ETF	118.005	118.34	117.99	118.33	16923344.0
2010-04-08 12:00:00	SPY	ETF	118.32	118.66	118.27	118.648	19102148.0
2010-04-08 13:00:00	SPY	ETF	118.645	118.82	118.6	118.655	18876703.0
2010-04-08 14:00:00	SPY	ETF	118.65	118.97	118.2	118.885	12661832.0
2010-04-08 15:00:00	SPY	ETF	118.89	118.97	118.74	118.76	23038867.0
2010-04-08 16:00:00	SPY	ETF	118.76	118.92	117.65	118.89	12225031.0
2010-04-08 17:00:00	SPY	ETF	118.3527	118.91	118.3527	118.85	1613675.0
2010-04-08 18:00:00	SPY	ETF	118.87	118.92	118.83	118.88	131119.0
2010-04-08 19:00:00	SPY	ETF	118.88	118.92	118.88	118.92	77000.0
2010-04-08 07:00:00	QQQ	ETF	48.53	48.54	48.46	48.47	22067.0
2010-04-08 08:00:00	QQQ	ETF	48.48	48.56	48.41	48.51	399397.0
2010-04-08 09:00:00	QQQ	ETF	48.52	48.54	48.24	48.29	11067625.0
2010-04-08 10:00:00	QQQ	ETF	48.29	48.51	48.2601	48.43	11971915.0
2010-04-08 11:00:00	QQQ	ETF	48.42	48.575	48.326	48.55	5856275.0
2010-04-08 12:00:00	QQQ	ETF	48.56	48.78	48.53	48.77	7001388.0
2010-04-08 13:00:00	QQQ	ETF	48.77	48.82	48.67	48.691	8442911.0
2010-04-08 14:00:00	QQQ	ETF	48.69	48.8143	48.67	48.775	5714472.0
2010-04-08 15:00:00	QQQ	ETF	48.77	48.8	48.69	48.71	8341346.0
2010-04-08 16:00:00	QQQ	ETF	48.72	48.8143	48.28	48.74	4836743.0
2010-04-08 17:00:00	QQQ	ETF	48.75	48.76	48.72	48.73	7520.0
2010-04-08 18:00:00	QQQ	ETF	48.74	48.75	48.73	48.74	23100.0
2010-04-08 19:00:00	QQQ	ETF	48.76	48.77	48.75	48.77	3599.0
2010-04-08 06:00:00	IWM	ETF	69.6	69.6	69.6	69.6	125.0
2010-04-08 07:00:00	IWM	ETF	69.62	69.65	69.49	69.49	96349.0
2010-04-08 08:00:00	IWM	ETF	69.61	69.62	69.43	69.58	835601.0
2010-04-08 09:00:00	IWM	ETF	69.6	69.7	69.16	69.31	10361287.0
2010-04-08 10:00:00	IWM	ETF	69.3	69.61	69.165	69.51	6334851.0
2010-04-08 11:00:00	IWM	ETF	69.5	69.77	69.5	69.74	4990838.0
2010-04-08 12:00:00	IWM	ETF	69.73	69.9	69.65	69.9	4365674.0
2010-04-08 13:00:00	IWM	ETF	69.9	70.02	69.55	69.829	5678624.0
2010-04-08 14:00:00	IWM	ETF	69.82	70.2	69.815	70.11	4796469.0
2010-04-08 15:00:00	IWM	ETF	70.1	70.16	69.87	69.88	10416423.0
2010-04-08 16:00:00	IWM	ETF	69.87	70.015	69.1261	69.9363	5590135.0
2010-04-08 17:00:00	IWM	ETF	69.87	69.87	69.87	69.87	3200.0
2010-04-08 18:00:00	IWM	ETF	69.91	69.92	69.85	69.92	1600.0
2010-04-08 19:00:00	IWM	ETF	69.92	69.95	69.92	69.95	1400.0
2010-04-08 07:00:00	DIA	ETF	108.71	108.71	108.68	108.68	2000.0
2010-04-08 08:00:00	DIA	ETF	108.67	108.79	108.55	108.75	35125.0
2010-04-08 09:00:00	DIA	ETF	108.74	108.79	108.5	108.61	1611295.0
2010-04-08 10:00:00	DIA	ETF	108.61	108.87	108.54	108.76	1221754.0
2010-04-08 11:00:00	DIA	ETF	108.76	109.06	108.74	109.0595	769436.0
2010-04-08 12:00:00	DIA	ETF	109.06	109.34	108.96	109.33	1015356.0
2010-04-08 13:00:00	DIA	ETF	109.3301	109.5	109.33	109.38	1299959.0

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

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