PREVIEW / etf_1hour / 2010-10-14

all etf 1-hour files

  file:    by_date/etf_1hour/2010/2010-10-14.parquet
  size:    172 KB
  rows:    5,324

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-10-14 04:00:00	SPY	ETF	118.01	118.49	118.01	118.39	3300.0
2010-10-14 05:00:00	SPY	ETF	118.28	118.33	118.1	118.1	7675.0
2010-10-14 06:00:00	SPY	ETF	118.18	118.19	117.95	118.13	117200.0
2010-10-14 07:00:00	SPY	ETF	118.14	118.21	118.01	118.09	314083.0
2010-10-14 08:00:00	SPY	ETF	118.08	118.34	117.93	117.97	3231068.0
2010-10-14 09:00:00	SPY	ETF	117.96	117.98	117.43	117.49	31462532.0
2010-10-14 10:00:00	SPY	ETF	117.49	118.01	117.47	117.9	25479171.0
2010-10-14 11:00:00	SPY	ETF	117.9	117.93	117.19	117.38	25622720.0
2010-10-14 12:00:00	SPY	ETF	117.38	117.49	117.07	117.31	17057615.0
2010-10-14 13:00:00	SPY	ETF	117.31	117.36	116.92	117.32	25137586.0
2010-10-14 14:00:00	SPY	ETF	117.313	117.32	116.79	116.83	21841702.0
2010-10-14 15:00:00	SPY	ETF	116.83	117.8972	116.72	117.52	41952264.0
2010-10-14 16:00:00	SPY	ETF	117.52	118.11	116.825	118.01	12686086.0
2010-10-14 17:00:00	SPY	ETF	118.0	118.03	117.4812	117.94	5177785.0
2010-10-14 18:00:00	SPY	ETF	117.95	118.02	117.55	117.97	222712.0
2010-10-14 19:00:00	SPY	ETF	117.96	117.96	117.71	117.76	216766.0
2010-10-14 04:00:00	QQQ	ETF	50.75	50.75	50.7	50.7	1200.0
2010-10-14 05:00:00	QQQ	ETF	50.69	50.69	50.69	50.69	400.0
2010-10-14 06:00:00	QQQ	ETF	50.55	50.61	50.55	50.59	15100.0
2010-10-14 07:00:00	QQQ	ETF	50.61	50.69	50.58	50.64	647357.0
2010-10-14 08:00:00	QQQ	ETF	50.64	50.69	50.55	50.6	1178259.0
2010-10-14 09:00:00	QQQ	ETF	50.59	50.59	50.34	50.38	10704208.0
2010-10-14 10:00:00	QQQ	ETF	50.38	50.64	50.37	50.6	6035889.0
2010-10-14 11:00:00	QQQ	ETF	50.6	50.61	50.34	50.41	7002267.0
2010-10-14 12:00:00	QQQ	ETF	50.4101	50.48	50.3	50.41	4648671.0
2010-10-14 13:00:00	QQQ	ETF	50.41	50.44	50.23	50.41	7920023.0
2010-10-14 14:00:00	QQQ	ETF	50.41	50.42	50.18	50.21	5842083.0
2010-10-14 15:00:00	QQQ	ETF	50.2	50.43	50.17	50.43	8722209.0
2010-10-14 16:00:00	QQQ	ETF	50.43	50.89	50.38	50.88	8832148.0
2010-10-14 17:00:00	QQQ	ETF	50.88	50.91	50.85	50.88	513616.0
2010-10-14 18:00:00	QQQ	ETF	50.88	50.91	50.86	50.9	25787.0
2010-10-14 19:00:00	QQQ	ETF	50.87	50.91	50.78	50.91	74669.0
2010-10-14 04:00:00	IWM	ETF	71.1	71.1	71.07	71.07	3000.0
2010-10-14 05:00:00	IWM	ETF	70.98	70.98	70.98	70.98	100.0
2010-10-14 06:00:00	IWM	ETF	70.95	70.95	70.82	70.94	3400.0
2010-10-14 07:00:00	IWM	ETF	70.85	70.97	70.81	70.93	58100.0
2010-10-14 08:00:00	IWM	ETF	70.9	70.97	70.7	70.71	353993.0
2010-10-14 09:00:00	IWM	ETF	70.7	70.72	70.28	70.48	8590191.0
2010-10-14 10:00:00	IWM	ETF	70.48	70.94	70.47	70.9295	6087136.0
2010-10-14 11:00:00	IWM	ETF	70.92	70.95	70.37	70.478	5544163.0
2010-10-14 12:00:00	IWM	ETF	70.47	70.56	70.27	70.4985	5411500.0
2010-10-14 13:00:00	IWM	ETF	70.5	70.57	70.19	70.52	11322455.0
2010-10-14 14:00:00	IWM	ETF	70.52	70.53	70.07	70.12	4890930.0
2010-10-14 15:00:00	IWM	ETF	70.11	70.58	69.89	70.5	15575776.0
2010-10-14 16:00:00	IWM	ETF	70.57	71.06	70.5	71.02	6758753.0
2010-10-14 17:00:00	IWM	ETF	71.02	71.03	70.98	71.02	97348.0
2010-10-14 18:00:00	IWM	ETF	70.99	71.03	70.5	71.01	8183.0
2010-10-14 19:00:00	IWM	ETF	70.96	70.96	70.82	70.82	12197.0
2010-10-14 06:00:00	DIA	ETF	111.25	111.25	111.15	111.15	900.0
2010-10-14 07:00:00	DIA	ETF	111.24	111.35	111.24	111.35	800.0

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

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