PREVIEW / etf_1hour / 2010-04-19

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-04-19.parquet
  size:    164 KB
  rows:    4,974

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-19 04:00:00	SPY	ETF	119.02	119.08	118.8	118.94	8050.0
2010-04-19 05:00:00	SPY	ETF	118.78	118.94	118.78	118.88	22700.0
2010-04-19 06:00:00	SPY	ETF	118.92	119.0	118.85	118.96	30100.0
2010-04-19 07:00:00	SPY	ETF	118.98	118.98	118.66	118.92	645971.0
2010-04-19 08:00:00	SPY	ETF	118.89	119.41	118.76	119.03	2439649.0
2010-04-19 09:00:00	SPY	ETF	119.02	119.67	118.98	119.49	29751476.0
2010-04-19 10:00:00	SPY	ETF	119.48	119.81	119.21	119.33	36049786.0
2010-04-19 11:00:00	SPY	ETF	119.32	119.39	118.61	118.73	32562870.0
2010-04-19 12:00:00	SPY	ETF	118.74	118.96	118.47	118.91	25141094.0
2010-04-19 13:00:00	SPY	ETF	118.89	118.98	118.64	118.66	15547899.0
2010-04-19 14:00:00	SPY	ETF	118.66	119.58	118.57	119.56	28668296.0
2010-04-19 15:00:00	SPY	ETF	119.56	119.93	119.5	119.85	32567073.0
2010-04-19 16:00:00	SPY	ETF	119.84	120.12	118.7	119.96	10746177.0
2010-04-19 17:00:00	SPY	ETF	119.98	120.05	119.3319	120.0	2149797.0
2010-04-19 18:00:00	SPY	ETF	119.99	120.07	119.98	120.06	215307.0
2010-04-19 19:00:00	SPY	ETF	120.06	120.1	120.04	120.09	135807.0
2010-04-19 04:00:00	QQQ	ETF	49.4	49.4	49.37	49.37	1100.0
2010-04-19 05:00:00	QQQ	ETF	49.28	49.28	49.28	49.28	4400.0
2010-04-19 06:00:00	QQQ	ETF	49.36	49.36	49.36	49.36	200.0
2010-04-19 07:00:00	QQQ	ETF	49.3	49.33	49.25	49.32	118882.0
2010-04-19 08:00:00	QQQ	ETF	49.33	49.41	49.25	49.41	616244.0
2010-04-19 09:00:00	QQQ	ETF	49.4	49.66	49.35	49.57	11706691.0
2010-04-19 10:00:00	QQQ	ETF	49.57	49.64	49.28	49.3295	16161217.0
2010-04-19 11:00:00	QQQ	ETF	49.32	49.35	48.98	49.03	9515843.0
2010-04-19 12:00:00	QQQ	ETF	49.03	49.1	48.9	49.06	11132577.0
2010-04-19 13:00:00	QQQ	ETF	49.06	49.08	48.93	48.9462	8992879.0
2010-04-19 14:00:00	QQQ	ETF	48.95	49.3125	48.91	49.31	13397176.0
2010-04-19 15:00:00	QQQ	ETF	49.31	49.55	49.3	49.5025	17168191.0
2010-04-19 16:00:00	QQQ	ETF	49.5	49.63	49.313	49.52	7546975.0
2010-04-19 17:00:00	QQQ	ETF	49.54	49.55	49.51	49.52	7200.0
2010-04-19 18:00:00	QQQ	ETF	49.54	49.56	49.52	49.56	29491.0
2010-04-19 19:00:00	QQQ	ETF	49.56	49.57	49.54	49.57	14240.0
2010-04-19 05:00:00	IWM	ETF	71.09	71.09	71.02	71.02	2500.0
2010-04-19 06:00:00	IWM	ETF	71.01	71.11	71.01	71.06	500.0
2010-04-19 07:00:00	IWM	ETF	70.95	71.03	70.9	71.0	37236.0
2010-04-19 08:00:00	IWM	ETF	71.03	71.2	70.93	71.16	201887.0
2010-04-19 09:00:00	IWM	ETF	71.15	71.63	71.01	71.44	8187686.0
2010-04-19 10:00:00	IWM	ETF	71.44	71.77	71.28	71.37	11553254.0
2010-04-19 11:00:00	IWM	ETF	71.36	71.42	70.3	70.34	12025935.0
2010-04-19 12:00:00	IWM	ETF	70.35	70.71	70.13	70.58	11301903.0
2010-04-19 13:00:00	IWM	ETF	70.58	70.6	70.29	70.305	7519917.0
2010-04-19 14:00:00	IWM	ETF	70.3	71.14	69.78	71.12	14054223.0
2010-04-19 15:00:00	IWM	ETF	71.14	71.25	70.88	71.12	10339259.0
2010-04-19 16:00:00	IWM	ETF	71.12	71.78	70.1094	71.25	7941037.0
2010-04-19 17:00:00	IWM	ETF	71.26	71.3	70.4509	70.4509	11000.0
2010-04-19 18:00:00	IWM	ETF	71.35	71.38	71.27	71.36	1859.0
2010-04-19 19:00:00	IWM	ETF	71.3	71.33	71.29	71.29	1100.0
2010-04-19 07:00:00	DIA	ETF	109.9	109.9	109.78	109.79	1950.0
2010-04-19 08:00:00	DIA	ETF	109.85	109.97	109.76	109.97	24496.0
2010-04-19 09:00:00	DIA	ETF	109.94	110.4842	109.84	110.32	1670680.0

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

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