PREVIEW / etf_1hour / 2008-03-17

all etf 1-hour files

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

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-17 04:00:00	SPY	ETF	127.06	127.27	126.49	126.49	25400.0
2008-03-17 05:00:00	SPY	ETF	126.51	127.05	126.4	127.01	102700.0
2008-03-17 06:00:00	SPY	ETF	126.96	127.17	126.55	126.9	907900.0
2008-03-17 07:00:00	SPY	ETF	126.92	127.41	126.64	127.0	5940800.0
2008-03-17 08:00:00	SPY	ETF	126.99	127.2	125.628	126.27	16185789.0
2008-03-17 09:00:00	SPY	ETF	126.27	130.5	125.9	127.37	55704521.0
2008-03-17 10:00:00	SPY	ETF	127.37	129.2532	127.19	128.33	68426217.0
2008-03-17 11:00:00	SPY	ETF	128.33	128.5	126.93	126.94	40108375.0
2008-03-17 12:00:00	SPY	ETF	126.93	127.35	126.36	127.14	38100232.0
2008-03-17 13:00:00	SPY	ETF	127.14	127.27	126.07	127.21	35318521.0
2008-03-17 14:00:00	SPY	ETF	127.21	128.36	126.88	127.96	40332282.0
2008-03-17 15:00:00	SPY	ETF	127.97	129.26	127.71	127.9	82108328.0
2008-03-17 16:00:00	SPY	ETF	127.83	128.65	127.8	128.27	13515800.0
2008-03-17 17:00:00	SPY	ETF	128.26	128.75	128.22	128.6	2540800.0
2008-03-17 18:00:00	SPY	ETF	128.61	128.87	128.58	128.85	229400.0
2008-03-17 19:00:00	SPY	ETF	128.82	128.85	128.58	128.58	98100.0
2008-03-17 04:00:00	QQQ	ETF	41.44	41.44	41.27	41.27	1871.0
2008-03-17 05:00:00	QQQ	ETF	41.25	41.25	41.25	41.25	499.0
2008-03-17 06:00:00	QQQ	ETF	41.47	41.5	41.35	41.46	85938.0
2008-03-17 07:00:00	QQQ	ETF	41.44	41.59	41.25	41.38	1494519.0
2008-03-17 08:00:00	QQQ	ETF	41.36	42.27	40.81	41.19	4869063.0
2008-03-17 09:00:00	QQQ	ETF	41.19	41.85	41.15	41.6	29851836.0
2008-03-17 10:00:00	QQQ	ETF	41.6	41.99	41.51	41.75	27336729.0
2008-03-17 11:00:00	QQQ	ETF	41.75	41.88	41.37	41.38	20590250.0
2008-03-17 12:00:00	QQQ	ETF	41.37	41.46	41.2	41.36	19971687.0
2008-03-17 13:00:00	QQQ	ETF	41.37	41.43	41.05	41.407	19385442.0
2008-03-17 14:00:00	QQQ	ETF	41.41	41.73	41.23	41.58	21532905.0
2008-03-17 15:00:00	QQQ	ETF	41.58	42.01	41.49	41.49	34787139.0
2008-03-17 16:00:00	QQQ	ETF	41.5	41.9056	41.45	41.62	3673735.0
2008-03-17 17:00:00	QQQ	ETF	41.62	42.1806	41.61	41.7	5422039.0
2008-03-17 18:00:00	QQQ	ETF	41.71	41.77	41.69	41.77	150175.0
2008-03-17 19:00:00	QQQ	ETF	41.76	41.77	41.74	41.75	29563.0
2008-03-17 04:00:00	IWM	ETF	64.43	64.43	64.43	64.43	2500.0
2008-03-17 06:00:00	IWM	ETF	64.23	64.24	64.23	64.24	600.0
2008-03-17 07:00:00	IWM	ETF	64.3	64.65	64.3	64.53	333800.0
2008-03-17 08:00:00	IWM	ETF	64.54	64.62	63.9	64.34	497380.0
2008-03-17 09:00:00	IWM	ETF	64.34	65.29	64.19	64.92	15965575.0
2008-03-17 10:00:00	IWM	ETF	64.92	65.84	64.4	65.36	23579893.0
2008-03-17 11:00:00	IWM	ETF	65.38	65.5	64.71	64.77	10342313.0
2008-03-17 12:00:00	IWM	ETF	64.77	65.2	64.59	65.08	14370875.0
2008-03-17 13:00:00	IWM	ETF	65.08	65.12	64.48	64.96	11498747.0
2008-03-17 14:00:00	IWM	ETF	64.94	65.42	64.63	65.18	14025510.0
2008-03-17 15:00:00	IWM	ETF	65.17	65.94	64.87	64.9	22520769.0
2008-03-17 16:00:00	IWM	ETF	64.9	66.14	64.65	65.13	4257326.0
2008-03-17 17:00:00	IWM	ETF	65.11	65.32	65.11	65.24	14100.0
2008-03-17 18:00:00	IWM	ETF	65.31	65.35	65.2	65.35	36400.0
2008-03-17 19:00:00	IWM	ETF	65.36	65.36	65.24	65.24	400.0
2008-03-17 04:00:00	DIA	ETF	118.01	118.01	118.01	118.01	2000.0
2008-03-17 06:00:00	DIA	ETF	118.1	118.1	117.88	117.99	3500.0
2008-03-17 07:00:00	DIA	ETF	118.0	118.26	117.75	118.0	106100.0

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

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