PREVIEW / etf_1hour / 2010-02-08

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-02-08.parquet
  size:    155 KB
  rows:    4,771

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-02-08 04:00:00	SPY	ETF	106.99	107.05	106.72	106.81	14314.0
2010-02-08 05:00:00	SPY	ETF	106.84	106.84	106.43	106.47	45400.0
2010-02-08 06:00:00	SPY	ETF	106.39	106.58	106.32	106.37	68900.0
2010-02-08 07:00:00	SPY	ETF	106.37	106.78	106.1	106.67	1690385.0
2010-02-08 08:00:00	SPY	ETF	106.67	106.8	106.12	106.74	1483584.0
2010-02-08 09:00:00	SPY	ETF	106.73	106.9	106.08	106.47	33182868.0
2010-02-08 10:00:00	SPY	ETF	106.47	107.02	106.3682	107.0	39869228.0
2010-02-08 11:00:00	SPY	ETF	106.99	107.33	106.8	107.06	24099601.0
2010-02-08 12:00:00	SPY	ETF	107.06	107.18	106.86	107.02	13871318.0
2010-02-08 13:00:00	SPY	ETF	107.02	107.05	106.45	106.56	20000000.0
2010-02-08 14:00:00	SPY	ETF	106.57	106.85	106.43	106.52	19723807.0
2010-02-08 15:00:00	SPY	ETF	106.5175	106.8	105.8099	105.89	42595283.0
2010-02-08 16:00:00	SPY	ETF	105.88	107.1499	105.85	105.95	19838144.0
2010-02-08 17:00:00	SPY	ETF	105.98	106.8056	105.87	105.93	3120269.0
2010-02-08 18:00:00	SPY	ETF	105.93	106.1	105.92	106.02	99263.0
2010-02-08 19:00:00	SPY	ETF	106.0	106.18	105.96	106.02	123982.0
2010-02-08 04:00:00	QQQ	ETF	43.14	43.14	43.09	43.09	300.0
2010-02-08 05:00:00	QQQ	ETF	43.01	43.01	43.01	43.01	100.0
2010-02-08 06:00:00	QQQ	ETF	42.92	42.96	42.88	42.92	41200.0
2010-02-08 07:00:00	QQQ	ETF	42.89	43.05	42.8	43.02	787442.0
2010-02-08 08:00:00	QQQ	ETF	43.01	43.07	42.81	43.03	1728477.0
2010-02-08 09:00:00	QQQ	ETF	43.03	43.05	42.64	42.86	19684503.0
2010-02-08 10:00:00	QQQ	ETF	42.87	43.04	42.82	43.02	14985803.0
2010-02-08 11:00:00	QQQ	ETF	43.02	43.18	43.01	43.1	8342264.0
2010-02-08 12:00:00	QQQ	ETF	43.11	43.17	43.03	43.13	6033876.0
2010-02-08 13:00:00	QQQ	ETF	43.13	43.14	42.86	42.97	8699144.0
2010-02-08 14:00:00	QQQ	ETF	42.98	43.07	42.9	42.93	6918875.0
2010-02-08 15:00:00	QQQ	ETF	42.92	42.9501	42.64	42.66	15757068.0
2010-02-08 16:00:00	QQQ	ETF	42.67	42.9615	42.61	42.66	4674697.0
2010-02-08 17:00:00	QQQ	ETF	42.65	42.67	42.64	42.65	133813.0
2010-02-08 18:00:00	QQQ	ETF	42.66	42.71	42.66	42.71	31265.0
2010-02-08 19:00:00	QQQ	ETF	42.69	42.73	42.67	42.69	31306.0
2010-02-08 07:00:00	IWM	ETF	59.1	59.29	58.89	59.28	34889.0
2010-02-08 08:00:00	IWM	ETF	59.29	59.29	58.7	59.23	346914.0
2010-02-08 09:00:00	IWM	ETF	59.23	59.35	58.66	59.01	10044624.0
2010-02-08 10:00:00	IWM	ETF	59.01	59.38	58.89	59.36	8054356.0
2010-02-08 11:00:00	IWM	ETF	59.36	59.6	59.33	59.43	5096439.0
2010-02-08 12:00:00	IWM	ETF	59.44	59.495	59.29	59.35	4491495.0
2010-02-08 13:00:00	IWM	ETF	59.35	59.35	58.92	58.99	6002354.0
2010-02-08 14:00:00	IWM	ETF	59.0	59.14	58.85	58.96	5098804.0
2010-02-08 15:00:00	IWM	ETF	58.96	59.0	58.62	58.67	12010212.0
2010-02-08 16:00:00	IWM	ETF	58.67	59.3081	58.67	58.72	3567192.0
2010-02-08 17:00:00	IWM	ETF	59.3081	59.3081	58.7	58.71	531451.0
2010-02-08 18:00:00	IWM	ETF	58.71	58.74	58.71	58.74	9200.0
2010-02-08 19:00:00	IWM	ETF	58.79	58.82	58.7	58.73	6100.0
2010-02-08 06:00:00	DIA	ETF	100.0	100.0	100.0	100.0	300.0
2010-02-08 07:00:00	DIA	ETF	99.9	100.08	99.5	100.08	26570.0
2010-02-08 08:00:00	DIA	ETF	100.08	100.08	99.84	100.05	30862.0
2010-02-08 09:00:00	DIA	ETF	100.03	100.16	99.43	99.77	1916917.0
2010-02-08 10:00:00	DIA	ETF	99.78	100.12	99.7	100.1	2306145.0

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

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