PREVIEW / etf_1hour / 2007-10-10

all etf 1-hour files

  file:    by_date/etf_1hour/2007/2007-10-10.parquet
  size:    84 KB
  rows:    2,857

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-10-10 04:00:00	SPY	ETF	156.17	156.17	156.15	156.15	3100.0
2007-10-10 05:00:00	SPY	ETF	156.14	156.17	156.14	156.17	14500.0
2007-10-10 06:00:00	SPY	ETF	156.16	156.23	156.16	156.23	99700.0
2007-10-10 07:00:00	SPY	ETF	156.29	156.29	156.03	156.11	291900.0
2007-10-10 08:00:00	SPY	ETF	156.13	156.48	156.03	156.09	1290100.0
2007-10-10 09:00:00	SPY	ETF	156.08	156.48	155.76	155.79	11681224.0
2007-10-10 10:00:00	SPY	ETF	155.8	155.95	155.67	155.72	14793200.0
2007-10-10 11:00:00	SPY	ETF	155.71	156.17	155.71	155.81	12030192.0
2007-10-10 12:00:00	SPY	ETF	155.82	155.96	155.66	155.82	8657598.0
2007-10-10 13:00:00	SPY	ETF	155.82	155.83	155.41	155.62	14499800.0
2007-10-10 14:00:00	SPY	ETF	155.63	156.15	155.53	156.09	11694500.0
2007-10-10 15:00:00	SPY	ETF	156.09	156.44	155.99	156.03	20094600.0
2007-10-10 16:00:00	SPY	ETF	156.03	156.3988	155.85	156.09	4547800.0
2007-10-10 17:00:00	SPY	ETF	156.09	156.15	156.08	156.15	35400.0
2007-10-10 18:00:00	SPY	ETF	156.15	156.36	156.15	156.3	182300.0
2007-10-10 19:00:00	SPY	ETF	156.3	156.3	156.23	156.25	37200.0
2007-10-10 06:00:00	QQQ	ETF	53.37	53.4	53.37	53.4	6500.0
2007-10-10 07:00:00	QQQ	ETF	53.4	53.4	53.33	53.35	88856.0
2007-10-10 08:00:00	QQQ	ETF	53.36	53.43	53.34	53.41	820298.0
2007-10-10 09:00:00	QQQ	ETF	53.41	53.43	53.29	53.32	10494420.0
2007-10-10 10:00:00	QQQ	ETF	53.32	53.44	53.27	53.32	14836911.0
2007-10-10 11:00:00	QQQ	ETF	53.32	53.47	53.32	53.341	11143165.0
2007-10-10 12:00:00	QQQ	ETF	53.341	53.41	53.27	53.38	8981230.0
2007-10-10 13:00:00	QQQ	ETF	53.38	53.38	53.21	53.32	11062443.0
2007-10-10 14:00:00	QQQ	ETF	53.32	53.47	53.25	53.44	9443362.0
2007-10-10 15:00:00	QQQ	ETF	53.44	53.57	53.44	53.5	19425442.0
2007-10-10 16:00:00	QQQ	ETF	53.5	53.57	53.46	53.48	5501288.0
2007-10-10 17:00:00	QQQ	ETF	53.48	53.52	53.46	53.47	26591.0
2007-10-10 18:00:00	QQQ	ETF	53.48	53.54	53.48	53.54	28944.0
2007-10-10 19:00:00	QQQ	ETF	53.53	53.53	53.49	53.49	9400.0
2007-10-10 06:00:00	IWM	ETF	84.15	84.15	84.15	84.15	200.0
2007-10-10 07:00:00	IWM	ETF	84.2	84.2	84.12	84.12	111200.0
2007-10-10 08:00:00	IWM	ETF	84.15	84.2	84.09	84.1	336900.0
2007-10-10 09:00:00	IWM	ETF	84.08	84.23	83.83	83.87	3782851.0
2007-10-10 10:00:00	IWM	ETF	83.88	84.06	83.74	83.84	9751000.0
2007-10-10 11:00:00	IWM	ETF	83.85	84.09	83.81	83.84	4916300.0
2007-10-10 12:00:00	IWM	ETF	83.85	84.0	83.73	83.91	4145300.0
2007-10-10 13:00:00	IWM	ETF	83.91	83.91	83.44	83.65	7829829.0
2007-10-10 14:00:00	IWM	ETF	83.65	83.97	83.55	83.9	5437200.0
2007-10-10 15:00:00	IWM	ETF	83.9	84.22	83.9	84.09	11148300.0
2007-10-10 16:00:00	IWM	ETF	84.1	84.16	83.84	84.12	3202800.0
2007-10-10 17:00:00	IWM	ETF	84.16	84.18	84.16	84.18	1900.0
2007-10-10 18:00:00	IWM	ETF	84.13	84.15	83.99	84.15	6200.0
2007-10-10 19:00:00	IWM	ETF	84.18	84.18	84.18	84.18	400.0
2007-10-10 07:00:00	DIA	ETF	141.43	141.43	141.33	141.33	1000.0
2007-10-10 08:00:00	DIA	ETF	141.38	141.46	141.38	141.41	84000.0
2007-10-10 09:00:00	DIA	ETF	141.4	141.44	141.02	141.04	1094900.0
2007-10-10 10:00:00	DIA	ETF	141.01	141.17	140.85	140.9	1029600.0
2007-10-10 11:00:00	DIA	ETF	140.9	141.21	140.69	140.75	1357600.0
2007-10-10 12:00:00	DIA	ETF	140.75	140.78	140.45	140.49	1323800.0

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

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