PREVIEW / etf_1hour / 2010-07-13

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-07-13.parquet
  size:    166 KB
  rows:    5,069

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-07-13 04:00:00	SPY	ETF	108.08	108.64	108.03	108.6	4850.0
2010-07-13 05:00:00	SPY	ETF	108.6	108.93	108.6	108.88	20200.0
2010-07-13 06:00:00	SPY	ETF	108.86	108.88	108.77	108.79	48000.0
2010-07-13 07:00:00	SPY	ETF	108.79	109.05	108.75	108.99	741171.0
2010-07-13 08:00:00	SPY	ETF	108.97	109.18	108.56	109.12	1479582.0
2010-07-13 09:00:00	SPY	ETF	109.13	109.38	108.93	109.19	32172385.0
2010-07-13 10:00:00	SPY	ETF	109.19	109.59	109.11	109.25	28692404.0
2010-07-13 11:00:00	SPY	ETF	109.26	109.89	109.21	109.59	27508181.0
2010-07-13 12:00:00	SPY	ETF	109.5999	109.82	109.56	109.58	17701295.0
2010-07-13 13:00:00	SPY	ETF	109.58	109.77	109.27	109.37	18292150.0
2010-07-13 14:00:00	SPY	ETF	109.37	109.76	109.36	109.7483	17425570.0
2010-07-13 15:00:00	SPY	ETF	109.75	110.09	109.6	109.66	47668163.0
2010-07-13 16:00:00	SPY	ETF	109.66	110.33	108.015	110.23	19011312.0
2010-07-13 17:00:00	SPY	ETF	110.22	110.4	110.21	110.36	473885.0
2010-07-13 18:00:00	SPY	ETF	110.34	110.39	108.02	110.25	346845.0
2010-07-13 19:00:00	SPY	ETF	110.28	110.32	110.21	110.32	137644.0
2010-07-13 04:00:00	QQQ	ETF	44.84	45.05	44.84	45.05	25450.0
2010-07-13 05:00:00	QQQ	ETF	45.04	45.15	45.04	45.14	1550.0
2010-07-13 06:00:00	QQQ	ETF	45.15	45.15	45.15	45.15	1100.0
2010-07-13 07:00:00	QQQ	ETF	45.13	45.18	45.09	45.14	278607.0
2010-07-13 08:00:00	QQQ	ETF	45.14	45.24	45.13	45.2	529867.0
2010-07-13 09:00:00	QQQ	ETF	45.2	45.26	44.8	44.98	16134095.0
2010-07-13 10:00:00	QQQ	ETF	44.98	45.15	44.88	44.96	13500058.0
2010-07-13 11:00:00	QQQ	ETF	44.95	45.37	44.95	45.21	11855684.0
2010-07-13 12:00:00	QQQ	ETF	45.21	45.32	45.17	45.2	5602085.0
2010-07-13 13:00:00	QQQ	ETF	45.2	45.28	45.05	45.115	6766524.0
2010-07-13 14:00:00	QQQ	ETF	45.12	45.39	45.1	45.38	7669091.0
2010-07-13 15:00:00	QQQ	ETF	45.38	45.5	45.31	45.33	12347682.0
2010-07-13 16:00:00	QQQ	ETF	45.33	45.98	44.9546	45.71	8387347.0
2010-07-13 17:00:00	QQQ	ETF	45.7	45.89	45.7	45.88	1796265.0
2010-07-13 18:00:00	QQQ	ETF	45.88	45.9	45.85	45.88	622495.0
2010-07-13 19:00:00	QQQ	ETF	45.88	45.89	45.85	45.86	64629.0
2010-07-13 05:00:00	IWM	ETF	62.64	62.71	62.63	62.71	3100.0
2010-07-13 06:00:00	IWM	ETF	62.84	62.89	62.84	62.89	785.0
2010-07-13 07:00:00	IWM	ETF	62.86	63.0	62.79	62.84	63374.0
2010-07-13 08:00:00	IWM	ETF	62.82	63.1	62.81	63.05	795459.0
2010-07-13 09:00:00	IWM	ETF	63.06	63.19	62.84	63.05	9006712.0
2010-07-13 10:00:00	IWM	ETF	63.05	63.35	63.03	63.1	9846259.0
2010-07-13 11:00:00	IWM	ETF	63.09	63.81	63.08	63.63	11874021.0
2010-07-13 12:00:00	IWM	ETF	63.63	63.87	63.63	63.65	5139065.0
2010-07-13 13:00:00	IWM	ETF	63.65	63.77	63.42	63.55	5889863.0
2010-07-13 14:00:00	IWM	ETF	63.55	63.97	63.53	63.948	7987754.0
2010-07-13 15:00:00	IWM	ETF	63.97	64.44	63.97	64.19	18740641.0
2010-07-13 16:00:00	IWM	ETF	64.19	64.62	62.1466	64.57	7769228.0
2010-07-13 17:00:00	IWM	ETF	64.57	64.73	64.54	64.6	62393.0
2010-07-13 18:00:00	IWM	ETF	64.6	64.99	64.6	64.83	38605.0
2010-07-13 19:00:00	IWM	ETF	64.83	64.83	64.75	64.78	13800.0
2010-07-13 07:00:00	DIA	ETF	102.93	103.07	102.93	103.05	2400.0
2010-07-13 08:00:00	DIA	ETF	103.03	103.18	103.02	103.14	68477.0
2010-07-13 09:00:00	DIA	ETF	103.15	103.5	103.15	103.46	1523662.0

> showing 50 of 5,069 rows — these rows as CSV

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