PREVIEW / etf_30min / 2007-10-17

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-10-17.parquet
  size:    136 KB
  rows:    4,915

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-17 04:00:00	SPY	ETF	154.61	154.61	154.61	154.61	100.0
2007-10-17 04:30:00	SPY	ETF	154.63	154.63	154.63	154.63	3000.0
2007-10-17 06:30:00	SPY	ETF	154.4	154.45	154.32	154.45	104900.0
2007-10-17 07:00:00	SPY	ETF	154.5	154.8	154.49	154.79	603700.0
2007-10-17 07:30:00	SPY	ETF	154.78	154.89	154.77	154.77	966500.0
2007-10-17 08:00:00	SPY	ETF	154.8	154.98	154.65	154.86	3886400.0
2007-10-17 08:30:00	SPY	ETF	154.82	154.97	154.7	154.94	3365400.0
2007-10-17 09:00:00	SPY	ETF	154.96	155.16	154.94	155.0	1997174.0
2007-10-17 09:30:00	SPY	ETF	154.98	155.09	154.59	154.68	15584208.0
2007-10-17 10:00:00	SPY	ETF	154.679	154.8	154.53	154.6	7705400.0
2007-10-17 10:30:00	SPY	ETF	154.59	154.74	154.27	154.36	12235050.0
2007-10-17 11:00:00	SPY	ETF	154.36	154.4	154.13	154.29	9052100.0
2007-10-17 11:30:00	SPY	ETF	154.29	154.62	154.27	154.47	8588100.0
2007-10-17 12:00:00	SPY	ETF	154.46	154.5	153.82	153.88	7930050.0
2007-10-17 12:30:00	SPY	ETF	153.88	153.96	153.44	153.4875	12440400.0
2007-10-17 13:00:00	SPY	ETF	153.48	153.61	152.9	153.03	24347300.0
2007-10-17 13:30:00	SPY	ETF	153.03	153.43	152.47	152.68	20575200.0
2007-10-17 14:00:00	SPY	ETF	152.68	153.08	152.52	152.91	20755113.0
2007-10-17 14:30:00	SPY	ETF	152.92	153.27	152.65	153.18	13300300.0
2007-10-17 15:00:00	SPY	ETF	153.1799	153.85	153.14	153.57	20081849.0
2007-10-17 15:30:00	SPY	ETF	153.58	154.06	153.23	154.03	17768794.0
2007-10-17 16:00:00	SPY	ETF	154.05	154.9723	153.22	154.42	8553700.0
2007-10-17 16:30:00	SPY	ETF	154.4	154.47	154.25	154.4	2580000.0
2007-10-17 17:00:00	SPY	ETF	154.38	154.41	154.31	154.35	133300.0
2007-10-17 17:30:00	SPY	ETF	154.28	154.32	154.2	154.22	45700.0
2007-10-17 18:00:00	SPY	ETF	154.2	154.25	154.15	154.2	21900.0
2007-10-17 18:30:00	SPY	ETF	154.22	154.29	154.21	154.24	25900.0
2007-10-17 19:00:00	SPY	ETF	154.2	154.2	154.1	154.11	6300.0
2007-10-17 19:30:00	SPY	ETF	154.13	154.23	154.13	154.23	8100.0
2007-10-17 04:00:00	QQQ	ETF	53.5	53.5	53.5	53.5	1000.0
2007-10-17 05:30:00	QQQ	ETF	53.44	53.44	53.44	53.44	2000.0
2007-10-17 06:30:00	QQQ	ETF	53.44	53.44	53.38	53.39	500.0
2007-10-17 07:00:00	QQQ	ETF	53.4	53.55	53.4	53.53	281036.0
2007-10-17 07:30:00	QQQ	ETF	53.53	53.56	53.51	53.51	213618.0
2007-10-17 08:00:00	QQQ	ETF	53.53	53.66	53.51	53.58	293351.0
2007-10-17 08:30:00	QQQ	ETF	53.56	53.64	53.51	53.63	590835.0
2007-10-17 09:00:00	QQQ	ETF	53.63	53.72	53.6	53.61	2345720.0
2007-10-17 09:30:00	QQQ	ETF	53.61	53.66	53.41	53.4674	18904354.0
2007-10-17 10:00:00	QQQ	ETF	53.46	53.56	53.43	53.47	6823638.0
2007-10-17 10:30:00	QQQ	ETF	53.47	53.55	53.35	53.49	9995036.0
2007-10-17 11:00:00	QQQ	ETF	53.49	53.53	53.41	53.4601	6822387.0
2007-10-17 11:30:00	QQQ	ETF	53.47	53.64	53.46	53.573	10572832.0
2007-10-17 12:00:00	QQQ	ETF	53.57	53.59	53.33	53.34	7317778.0
2007-10-17 12:30:00	QQQ	ETF	53.34	53.3699	53.12	53.12	9910937.0
2007-10-17 13:00:00	QQQ	ETF	53.12	53.17	52.85	52.88	18265757.0
2007-10-17 13:30:00	QQQ	ETF	52.885	53.08	52.68	52.72	19918900.0
2007-10-17 14:00:00	QQQ	ETF	52.729	52.96	52.68	52.81	16263541.0
2007-10-17 14:30:00	QQQ	ETF	52.81	53.04	52.74	53.0201	12410889.0
2007-10-17 15:00:00	QQQ	ETF	53.02	53.29	53.01	53.22	15420934.0
2007-10-17 15:30:00	QQQ	ETF	53.2275	53.58	53.2	53.55	19530870.0

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

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