PREVIEW / etf_1hour / 2009-07-27

all etf 1-hour files

  file:    by_date/etf_1hour/2009/2009-07-27.parquet
  size:    142 KB
  rows:    4,425

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
2009-07-27 04:00:00	SPY	ETF	98.3	98.3	98.3	98.3	150.0
2009-07-27 05:00:00	SPY	ETF	98.25	98.5	98.25	98.5	25720.0
2009-07-27 06:00:00	SPY	ETF	98.5	98.64	98.48	98.64	16350.0
2009-07-27 07:00:00	SPY	ETF	98.6	98.6	98.16	98.28	660352.0
2009-07-27 08:00:00	SPY	ETF	98.28	98.65	97.89	98.18	1607403.0
2009-07-27 09:00:00	SPY	ETF	98.2	98.3	97.72	97.91	22640004.0
2009-07-27 10:00:00	SPY	ETF	97.91	98.4	97.34	97.52	36616690.0
2009-07-27 11:00:00	SPY	ETF	97.5183	98.02	97.49	97.71	18188332.0
2009-07-27 12:00:00	SPY	ETF	97.72	97.87	97.63	97.79	9938422.0
2009-07-27 13:00:00	SPY	ETF	97.8	98.0	97.53	97.94	13052990.0
2009-07-27 14:00:00	SPY	ETF	97.95	98.26	97.83	98.16	16242289.0
2009-07-27 15:00:00	SPY	ETF	98.1683	98.38	97.86	98.35	26926710.0
2009-07-27 16:00:00	SPY	ETF	98.36	98.44	97.55	98.34	7102179.0
2009-07-27 17:00:00	SPY	ETF	98.33	98.46	98.33	98.45	336611.0
2009-07-27 18:00:00	SPY	ETF	98.44	98.45	97.99	98.28	281494.0
2009-07-27 19:00:00	SPY	ETF	98.26	98.28	98.22	98.22	42068.0
2009-07-27 04:00:00	QQQ	ETF	39.33	39.38	39.33	39.38	2400.0
2009-07-27 05:00:00	QQQ	ETF	39.3	39.46	39.3	39.45	1600.0
2009-07-27 06:00:00	QQQ	ETF	39.47	39.55	39.44	39.55	15800.0
2009-07-27 07:00:00	QQQ	ETF	39.51	39.53	39.35	39.43	260169.0
2009-07-27 08:00:00	QQQ	ETF	39.43	39.44	39.25	39.36	648125.0
2009-07-27 09:00:00	QQQ	ETF	39.36	39.4	39.142	39.18	15336661.0
2009-07-27 10:00:00	QQQ	ETF	39.19	39.41	38.87	39.0	22880734.0
2009-07-27 11:00:00	QQQ	ETF	38.99	39.24	38.99	39.09	9460142.0
2009-07-27 12:00:00	QQQ	ETF	39.1	39.2	39.05	39.1	6908668.0
2009-07-27 13:00:00	QQQ	ETF	39.1099	39.2	39.0	39.18	5999991.0
2009-07-27 14:00:00	QQQ	ETF	39.17	39.33	39.1	39.2501	8415802.0
2009-07-27 15:00:00	QQQ	ETF	39.25	39.36	39.1	39.34	14550601.0
2009-07-27 16:00:00	QQQ	ETF	39.35	39.4	39.184	39.35	4067723.0
2009-07-27 17:00:00	QQQ	ETF	39.35	39.42	39.35	39.42	268454.0
2009-07-27 18:00:00	QQQ	ETF	39.42	39.42	39.31	39.31	154463.0
2009-07-27 19:00:00	QQQ	ETF	39.32	39.32	39.29	39.3	33308.0
2009-07-27 07:00:00	IWM	ETF	55.2	55.2	55.0	55.1	14800.0
2009-07-27 08:00:00	IWM	ETF	55.12	55.12	54.74	54.91	232239.0
2009-07-27 09:00:00	IWM	ETF	54.89	55.01	54.58	54.76	5250544.0
2009-07-27 10:00:00	IWM	ETF	54.77	55.22	54.42	54.58	6270294.0
2009-07-27 11:00:00	IWM	ETF	54.57	54.9	54.568	54.715	2608877.0
2009-07-27 12:00:00	IWM	ETF	54.728	54.8	54.6	54.75	3422604.0
2009-07-27 13:00:00	IWM	ETF	54.74	54.82	54.6	54.78	2405996.0
2009-07-27 14:00:00	IWM	ETF	54.78	55.06	54.75	54.97	2947389.0
2009-07-27 15:00:00	IWM	ETF	54.98	55.08	54.72	55.08	7389037.0
2009-07-27 16:00:00	IWM	ETF	55.08	55.13	55.03	55.1	1131586.0
2009-07-27 17:00:00	IWM	ETF	55.09	55.12	55.08	55.11	6556.0
2009-07-27 18:00:00	IWM	ETF	55.07	55.07	54.8	54.99	9780.0
2009-07-27 19:00:00	IWM	ETF	55.03	55.05	55.03	55.05	427.0
2009-07-27 07:00:00	DIA	ETF	91.26	91.26	91.18	91.19	1200.0
2009-07-27 08:00:00	DIA	ETF	91.22	91.22	90.88	91.02	37454.0
2009-07-27 09:00:00	DIA	ETF	91.0	91.03	90.69	90.85	2016608.0
2009-07-27 10:00:00	DIA	ETF	90.87	91.27	90.37	90.51	2621125.0
2009-07-27 11:00:00	DIA	ETF	90.5	90.88	90.49	90.6506	1044809.0

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

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