PREVIEW / etf_1hour / 2008-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2008/2008-03-10.parquet
  size:    106 KB
  rows:    3,509

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
2008-03-10 04:00:00	SPY	ETF	129.87	129.87	129.3	129.52	300.0
2008-03-10 05:00:00	SPY	ETF	129.36	129.36	129.25	129.25	200.0
2008-03-10 06:00:00	SPY	ETF	129.67	129.82	129.55	129.76	38400.0
2008-03-10 07:00:00	SPY	ETF	129.84	130.26	129.74	129.9	1514700.0
2008-03-10 08:00:00	SPY	ETF	129.91	130.19	129.0	129.86	2949188.0
2008-03-10 09:00:00	SPY	ETF	129.84	129.99	129.1	129.62	19334083.0
2008-03-10 10:00:00	SPY	ETF	129.62	129.93	129.0	129.4	31299873.0
2008-03-10 11:00:00	SPY	ETF	129.4	129.75	128.21	128.75	38429614.0
2008-03-10 12:00:00	SPY	ETF	128.76	129.18	128.15	129.03	33329666.0
2008-03-10 13:00:00	SPY	ETF	129.03	129.12	128.27	128.3	15855508.0
2008-03-10 14:00:00	SPY	ETF	128.29	128.43	127.59	127.96	37617375.0
2008-03-10 15:00:00	SPY	ETF	127.97	128.31	127.63	127.86	48010972.0
2008-03-10 16:00:00	SPY	ETF	127.89	128.18	127.56	127.75	3566400.0
2008-03-10 17:00:00	SPY	ETF	127.71	128.0	127.61	127.72	391300.0
2008-03-10 18:00:00	SPY	ETF	127.72	128.0	127.66	127.8	101700.0
2008-03-10 19:00:00	SPY	ETF	127.82	127.9	127.75	127.8	15800.0
2008-03-10 04:00:00	QQQ	ETF	41.97	41.97	41.97	41.97	127.0
2008-03-10 05:00:00	QQQ	ETF	41.89	41.89	41.89	41.89	300.0
2008-03-10 06:00:00	QQQ	ETF	42.07	42.18	42.07	42.18	1100.0
2008-03-10 07:00:00	QQQ	ETF	42.14	42.21	42.06	42.1	702713.0
2008-03-10 08:00:00	QQQ	ETF	42.1	42.13	41.78	42.03	1073024.0
2008-03-10 09:00:00	QQQ	ETF	42.03	42.12	41.82	42.01	16122745.0
2008-03-10 10:00:00	QQQ	ETF	42.02	42.14	41.84	41.92	22119689.0
2008-03-10 11:00:00	QQQ	ETF	41.92	42.03	41.52	41.64	24527507.0
2008-03-10 12:00:00	QQQ	ETF	41.64	41.74	41.47	41.71	22882199.0
2008-03-10 13:00:00	QQQ	ETF	41.72	41.74	41.43	41.44	10008900.0
2008-03-10 14:00:00	QQQ	ETF	41.4399	41.49	41.21	41.3	17271314.0
2008-03-10 15:00:00	QQQ	ETF	41.2905	41.44	41.17	41.22	26259747.0
2008-03-10 16:00:00	QQQ	ETF	41.22	41.6264	41.03	41.08	6304984.0
2008-03-10 17:00:00	QQQ	ETF	41.08	41.09	40.98	41.04	109867.0
2008-03-10 18:00:00	QQQ	ETF	41.05	41.13	41.05	41.09	125258.0
2008-03-10 19:00:00	QQQ	ETF	41.11	41.14	41.08	41.08	35058.0
2008-03-10 06:00:00	IWM	ETF	66.15	66.15	66.15	66.15	300.0
2008-03-10 07:00:00	IWM	ETF	66.21	66.39	66.17	66.17	324700.0
2008-03-10 08:00:00	IWM	ETF	66.29	66.29	66.04	66.19	593700.0
2008-03-10 09:00:00	IWM	ETF	66.2	66.2	65.47	65.67	6539197.0
2008-03-10 10:00:00	IWM	ETF	65.67	65.82	65.36	65.56	6263007.0
2008-03-10 11:00:00	IWM	ETF	65.55	65.8	64.62	65.13	18529040.0
2008-03-10 12:00:00	IWM	ETF	65.13	65.22	64.8	65.11	9253805.0
2008-03-10 13:00:00	IWM	ETF	65.11	65.15	64.56	64.58	7481982.0
2008-03-10 14:00:00	IWM	ETF	64.58	64.86	64.44	64.53	11789994.0
2008-03-10 15:00:00	IWM	ETF	64.54	65.6	64.1	64.26	15048653.0
2008-03-10 16:00:00	IWM	ETF	64.3	64.93	64.28	64.34	4569900.0
2008-03-10 17:00:00	IWM	ETF	64.42	64.48	64.23	64.28	2509000.0
2008-03-10 18:00:00	IWM	ETF	64.28	64.5	64.28	64.34	83100.0
2008-03-10 19:00:00	IWM	ETF	64.32	64.33	64.31	64.31	4000.0
2008-03-10 07:00:00	DIA	ETF	119.42	119.42	119.2	119.2	2700.0
2008-03-10 08:00:00	DIA	ETF	119.25	119.41	119.06	119.28	42000.0
2008-03-10 09:00:00	DIA	ETF	119.32	119.41	118.69	119.02	1478745.0
2008-03-10 10:00:00	DIA	ETF	119.03	119.29	118.62	118.99	2272796.0

> showing 50 of 3,509 rows — these rows as CSV

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