PREVIEW / etf_30min / 2007-11-15

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-15.parquet
  size:    140 KB
  rows:    5,103

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-11-15 05:30:00	SPY	ETF	146.82	146.82	146.82	146.82	12500.0
2007-11-15 06:00:00	SPY	ETF	146.78	146.78	146.75	146.75	25000.0
2007-11-15 06:30:00	SPY	ETF	146.87	146.95	146.87	146.95	78000.0
2007-11-15 07:00:00	SPY	ETF	146.95	147.05	146.8	146.92	443000.0
2007-11-15 07:30:00	SPY	ETF	146.95	147.19	146.66	146.7	585900.0
2007-11-15 08:00:00	SPY	ETF	146.71	147.17	146.7	147.1	2263300.0
2007-11-15 08:30:00	SPY	ETF	147.16	147.33	146.35	146.67	7729500.0
2007-11-15 09:00:00	SPY	ETF	146.66	146.8	146.5	146.79	1986750.0
2007-11-15 09:30:00	SPY	ETF	146.79	147.04	146.0	146.81	25152592.0
2007-11-15 10:00:00	SPY	ETF	146.81	147.25	146.53	147.04	15481359.0
2007-11-15 10:30:00	SPY	ETF	147.04	147.49	146.76	147.07	15862038.0
2007-11-15 11:00:00	SPY	ETF	147.07	147.37	146.92	146.98	9289484.0
2007-11-15 11:30:00	SPY	ETF	146.97	147.1	146.5	146.69	10891736.0
2007-11-15 12:00:00	SPY	ETF	146.7	147.0	146.35	146.35	12293881.0
2007-11-15 12:30:00	SPY	ETF	146.36	146.47	146.04	146.32	18832062.0
2007-11-15 13:00:00	SPY	ETF	146.32	146.65	146.18	146.44	9011340.0
2007-11-15 13:30:00	SPY	ETF	146.43	146.93	146.17	146.25	8838156.0
2007-11-15 14:00:00	SPY	ETF	146.26	146.29	145.88	146.1	16970768.0
2007-11-15 14:30:00	SPY	ETF	146.11	146.33	145.13	145.2	22697174.0
2007-11-15 15:00:00	SPY	ETF	145.21	145.8	144.86	145.54	27828549.0
2007-11-15 15:30:00	SPY	ETF	145.54	145.71	144.52	145.35	46115752.0
2007-11-15 16:00:00	SPY	ETF	145.42	147.1038	145.2073	145.6	4990100.0
2007-11-15 16:30:00	SPY	ETF	145.6	147.6	145.31	145.47	904000.0
2007-11-15 17:00:00	SPY	ETF	145.47	145.69	145.47	145.6	485100.0
2007-11-15 17:30:00	SPY	ETF	145.6	145.65	145.41	145.41	250500.0
2007-11-15 18:00:00	SPY	ETF	145.49	146.14	145.47	145.55	41800.0
2007-11-15 18:30:00	SPY	ETF	145.57	145.64	145.57	145.64	6400.0
2007-11-15 19:00:00	SPY	ETF	145.6	145.62	145.47	145.58	17900.0
2007-11-15 19:30:00	SPY	ETF	145.56	145.57	145.48	145.52	36100.0
2007-11-15 04:00:00	QQQ	ETF	50.0	50.0	50.0	50.0	200.0
2007-11-15 06:00:00	QQQ	ETF	49.93	49.93	49.93	49.93	500.0
2007-11-15 06:30:00	QQQ	ETF	49.92	50.0	49.92	50.0	3300.0
2007-11-15 07:00:00	QQQ	ETF	49.96	50.09	49.95	50.07	576629.0
2007-11-15 07:30:00	QQQ	ETF	50.08	50.17	49.91	49.92	1039521.0
2007-11-15 08:00:00	QQQ	ETF	49.94	50.19	49.93	50.08	3284127.0
2007-11-15 08:30:00	QQQ	ETF	50.11	50.31	49.91	50.04	2991989.0
2007-11-15 09:00:00	QQQ	ETF	50.05	50.07	49.9	50.0	2326088.0
2007-11-15 09:30:00	QQQ	ETF	50.0	50.39	49.99	50.18	24782330.0
2007-11-15 10:00:00	QQQ	ETF	50.178	50.45	50.08	50.33	16302880.0
2007-11-15 10:30:00	QQQ	ETF	50.32	50.54	50.2	50.32	19718770.0
2007-11-15 11:00:00	QQQ	ETF	50.32	50.48	50.26	50.36	6830237.0
2007-11-15 11:30:00	QQQ	ETF	50.3599	50.4	50.15	50.24	11310768.0
2007-11-15 12:00:00	QQQ	ETF	50.25	50.35	50.13	50.13	11180819.0
2007-11-15 12:30:00	QQQ	ETF	50.1399	50.16	49.87	50.0101	25897297.0
2007-11-15 13:00:00	QQQ	ETF	50.02	50.2	49.93	50.05	10886811.0
2007-11-15 13:30:00	QQQ	ETF	50.06	50.26	50.0	50.01	6879499.0
2007-11-15 14:00:00	QQQ	ETF	50.01	50.09	49.85	50.03	14186480.0
2007-11-15 14:30:00	QQQ	ETF	50.02	50.1199	49.5	49.5	17513187.0
2007-11-15 15:00:00	QQQ	ETF	49.51	49.9	49.43	49.75	26545890.0
2007-11-15 15:30:00	QQQ	ETF	49.75	49.93	49.37	49.8115	42878518.0

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

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