PREVIEW / etf_1hour / 2010-04-16

all etf 1-hour files

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

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-16 04:00:00	SPY	ETF	120.9	121.1	120.9	121.1	1850.0
2010-04-16 05:00:00	SPY	ETF	121.13	121.15	121.1	121.12	16600.0
2010-04-16 06:00:00	SPY	ETF	121.12	121.12	120.95	120.97	89191.0
2010-04-16 07:00:00	SPY	ETF	121.04	121.22	121.0	121.08	429672.0
2010-04-16 08:00:00	SPY	ETF	121.09	121.18	120.75	120.91	2233750.0
2010-04-16 09:00:00	SPY	ETF	120.91	121.08	120.49	120.54	31740979.0
2010-04-16 10:00:00	SPY	ETF	120.55	121.07	119.74	120.04	76142870.0
2010-04-16 11:00:00	SPY	ETF	120.05	120.24	119.07	119.2501	78449381.0
2010-04-16 12:00:00	SPY	ETF	119.26	119.32	118.75	119.27	38966216.0
2010-04-16 13:00:00	SPY	ETF	119.27	121.285	119.12	119.3283	28155149.0
2010-04-16 14:00:00	SPY	ETF	119.32	119.83	119.25	119.41	33322573.0
2010-04-16 15:00:00	SPY	ETF	119.41	119.82	119.175	119.36	50032966.0
2010-04-16 16:00:00	SPY	ETF	119.38	121.2844	119.06	119.46	15426129.0
2010-04-16 17:00:00	SPY	ETF	119.42	121.2844	119.4	119.42	8396359.0
2010-04-16 18:00:00	SPY	ETF	119.43	119.62	119.4	119.54	421239.0
2010-04-16 19:00:00	SPY	ETF	119.52	119.6	119.47	119.54	79045.0
2010-04-16 04:00:00	QQQ	ETF	49.98	49.98	49.98	49.98	100.0
2010-04-16 06:00:00	QQQ	ETF	49.97	49.98	49.97	49.98	1000.0
2010-04-16 07:00:00	QQQ	ETF	50.02	50.04	49.95	49.99	77617.0
2010-04-16 08:00:00	QQQ	ETF	49.99	50.05	49.95	49.96	723394.0
2010-04-16 09:00:00	QQQ	ETF	49.96	50.13	49.79	49.85	14114067.0
2010-04-16 10:00:00	QQQ	ETF	49.85	50.12	49.71	49.7938	24237270.0
2010-04-16 11:00:00	QQQ	ETF	49.79	49.87	49.43	49.5099	25847473.0
2010-04-16 12:00:00	QQQ	ETF	49.5	49.505	49.2	49.4399	17265504.0
2010-04-16 13:00:00	QQQ	ETF	49.44	49.55	49.35	49.4419	11453258.0
2010-04-16 14:00:00	QQQ	ETF	49.44	49.65	49.4301	49.5	8356799.0
2010-04-16 15:00:00	QQQ	ETF	49.5	49.66	49.42	49.53	18236033.0
2010-04-16 16:00:00	QQQ	ETF	49.53	49.5878	49.4299	49.5	3895343.0
2010-04-16 17:00:00	QQQ	ETF	49.49	49.54	49.45	49.46	31800.0
2010-04-16 18:00:00	QQQ	ETF	49.51	49.53	49.47	49.47	6300.0
2010-04-16 19:00:00	QQQ	ETF	49.47	49.51	49.47	49.51	8137.0
2010-04-16 06:00:00	IWM	ETF	72.18	72.18	72.18	72.18	500.0
2010-04-16 07:00:00	IWM	ETF	72.24	72.28	72.15	72.2	62956.0
2010-04-16 08:00:00	IWM	ETF	72.23	72.27	72.12	72.14	575730.0
2010-04-16 09:00:00	IWM	ETF	72.13	72.47	71.83	71.87	12028215.0
2010-04-16 10:00:00	IWM	ETF	71.86	72.38	71.5	71.89	15992842.0
2010-04-16 11:00:00	IWM	ETF	71.88	72.3	71.08	71.25	19242039.0
2010-04-16 12:00:00	IWM	ETF	71.25	71.39	70.94	71.34	9667735.0
2010-04-16 13:00:00	IWM	ETF	71.33	71.48	71.17	71.32	7417275.0
2010-04-16 14:00:00	IWM	ETF	71.31	71.66	71.26	71.45	8436007.0
2010-04-16 15:00:00	IWM	ETF	71.44	71.74	71.33	71.48	12587079.0
2010-04-16 16:00:00	IWM	ETF	71.4475	71.58	71.2199	71.42	4290647.0
2010-04-16 17:00:00	IWM	ETF	71.42	71.46	71.33	71.46	21518.0
2010-04-16 18:00:00	IWM	ETF	71.36	71.49	71.3	71.49	1800.0
2010-04-16 19:00:00	IWM	ETF	71.45	71.46	71.37	71.38	4600.0
2010-04-16 07:00:00	DIA	ETF	111.42	111.42	111.28	111.28	1100.0
2010-04-16 08:00:00	DIA	ETF	111.38	111.42	111.21	111.25	20573.0
2010-04-16 09:00:00	DIA	ETF	111.28	111.4	111.0	111.11	1754655.0
2010-04-16 10:00:00	DIA	ETF	111.1	111.5	110.62	110.85	5467870.0
2010-04-16 11:00:00	DIA	ETF	110.8499	110.98	109.97	110.11	6052281.0

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

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