PREVIEW / etf_1hour / 2007-03-29

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-03-29.parquet
  size:    68 KB
  rows:    2,110

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
2007-03-29 06:00:00	SPY	ETF	142.19	142.2	142.13	142.13	90400.0
2007-03-29 07:00:00	SPY	ETF	142.19	142.23	142.08	142.2	121600.0
2007-03-29 08:00:00	SPY	ETF	142.2	142.68	142.1	142.53	4790000.0
2007-03-29 09:00:00	SPY	ETF	142.56	142.61	142.2	142.24	11445818.0
2007-03-29 10:00:00	SPY	ETF	142.24	142.5	141.89	141.91	17085495.0
2007-03-29 11:00:00	SPY	ETF	141.91	142.3	141.61	141.61	19900988.0
2007-03-29 12:00:00	SPY	ETF	141.62	142.02	141.6	141.81	19164078.0
2007-03-29 13:00:00	SPY	ETF	141.81	141.91	141.39	141.47	15015651.0
2007-03-29 14:00:00	SPY	ETF	141.47	141.7	141.19	141.7	24462297.0
2007-03-29 15:00:00	SPY	ETF	141.69	142.27	141.62	142.12	21590820.0
2007-03-29 16:00:00	SPY	ETF	142.13	142.22	141.9	142.09	3199800.0
2007-03-29 17:00:00	SPY	ETF	142.11	142.2246	142.07	142.1	89100.0
2007-03-29 18:00:00	SPY	ETF	142.11	142.12	142.07	142.12	40800.0
2007-03-29 19:00:00	SPY	ETF	142.12	142.19	142.12	142.18	24000.0
2007-03-29 05:00:00	QQQ	ETF	43.72	43.72	43.72	43.72	600.0
2007-03-29 07:00:00	QQQ	ETF	43.69	43.71	43.67	43.7	58200.0
2007-03-29 08:00:00	QQQ	ETF	43.69	43.86	43.68	43.83	3157176.0
2007-03-29 09:00:00	QQQ	ETF	43.83	43.85	43.66	43.69	9511200.0
2007-03-29 10:00:00	QQQ	ETF	43.69	43.77	43.48	43.51	18406000.0
2007-03-29 11:00:00	QQQ	ETF	43.52	43.6	43.33	43.33	15392700.0
2007-03-29 12:00:00	QQQ	ETF	43.33	43.41	43.27	43.33	13086100.0
2007-03-29 13:00:00	QQQ	ETF	43.32	43.41	43.19	43.23	14605500.0
2007-03-29 14:00:00	QQQ	ETF	43.22	43.33	43.1	43.31	19884500.0
2007-03-29 15:00:00	QQQ	ETF	43.31	43.58	43.24	43.58	23247600.0
2007-03-29 16:00:00	QQQ	ETF	43.57	43.63	43.5	43.59	5164312.0
2007-03-29 17:00:00	QQQ	ETF	43.6	43.61	43.57	43.6	230582.0
2007-03-29 18:00:00	QQQ	ETF	43.6	43.6	43.57	43.58	37700.0
2007-03-29 19:00:00	QQQ	ETF	43.58	43.6	43.56	43.6	18910.0
2007-03-29 07:00:00	IWM	ETF	79.4	79.45	79.4	79.45	4800.0
2007-03-29 08:00:00	IWM	ETF	79.46	79.79	79.46	79.75	968500.0
2007-03-29 09:00:00	IWM	ETF	79.73	79.76	79.41	79.45	5389815.0
2007-03-29 10:00:00	IWM	ETF	79.44	79.59	79.05	79.2	5719535.0
2007-03-29 11:00:00	IWM	ETF	79.19	79.38	78.95	78.95	4978900.0
2007-03-29 12:00:00	IWM	ETF	78.95	79.11	78.87	79.01	4854974.0
2007-03-29 13:00:00	IWM	ETF	79.01	79.12	78.62	78.65	6638304.0
2007-03-29 14:00:00	IWM	ETF	78.65	78.89	78.49	78.79	10732637.0
2007-03-29 15:00:00	IWM	ETF	78.8	79.31	78.72	79.27	8961544.0
2007-03-29 16:00:00	IWM	ETF	79.28	79.34	79.14	79.3	398900.0
2007-03-29 17:00:00	IWM	ETF	79.3	79.31	79.23	79.23	19700.0
2007-03-29 18:00:00	IWM	ETF	79.23	79.3	79.18	79.25	56400.0
2007-03-29 19:00:00	IWM	ETF	79.24	79.25	79.24	79.25	10100.0
2007-03-29 07:00:00	DIA	ETF	123.41	123.42	123.37	123.41	1100.0
2007-03-29 08:00:00	DIA	ETF	123.45	123.8	123.45	123.8	95400.0
2007-03-29 09:00:00	DIA	ETF	123.74	123.75	123.3	123.41	646100.0
2007-03-29 10:00:00	DIA	ETF	123.41	123.6	123.14	123.18	1021600.0
2007-03-29 11:00:00	DIA	ETF	123.17	123.45	122.98	122.98	1134130.0
2007-03-29 12:00:00	DIA	ETF	122.99	123.27	122.96	123.06	1048788.0
2007-03-29 13:00:00	DIA	ETF	123.06	123.18	122.69	122.77	1280402.0
2007-03-29 14:00:00	DIA	ETF	122.79	122.99	122.56	122.97	2316877.0
2007-03-29 15:00:00	DIA	ETF	122.96	123.48	122.92	123.37	1458052.0

> showing 50 of 2,110 rows — these rows as CSV

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