PREVIEW / etf_30min / 2007-12-27

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-12-27.parquet
  size:    141 KB
  rows:    5,244

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-12-27 06:30:00	SPY	ETF	149.41	149.43	149.41	149.43	6500.0
2007-12-27 07:00:00	SPY	ETF	149.5	149.63	149.5	149.61	37000.0
2007-12-27 07:30:00	SPY	ETF	149.63	149.63	149.55	149.59	30200.0
2007-12-27 08:00:00	SPY	ETF	149.63	149.63	149.18	149.32	1256600.0
2007-12-27 08:30:00	SPY	ETF	149.32	149.4	148.73	148.87	4734200.0
2007-12-27 09:00:00	SPY	ETF	148.87	149.01	148.77	149.0	550500.0
2007-12-27 09:30:00	SPY	ETF	149.02	149.03	148.58	148.6	11362986.0
2007-12-27 10:00:00	SPY	ETF	148.6	148.97	148.6	148.84	6493480.0
2007-12-27 10:30:00	SPY	ETF	148.83	148.9	148.38	148.46	7413276.0
2007-12-27 11:00:00	SPY	ETF	148.46	148.57	148.26	148.5	8782876.0
2007-12-27 11:30:00	SPY	ETF	148.5	148.54	148.32	148.5	5500181.0
2007-12-27 12:00:00	SPY	ETF	148.5	148.52	148.04	148.07	12957452.0
2007-12-27 12:30:00	SPY	ETF	148.06	148.12	147.78	147.98	7989727.0
2007-12-27 13:00:00	SPY	ETF	147.98	148.14	147.73	148.13	5902538.0
2007-12-27 13:30:00	SPY	ETF	148.13	148.24	147.98	148.08	3447401.0
2007-12-27 14:00:00	SPY	ETF	148.09	148.34	148.04	148.23	6246166.0
2007-12-27 14:30:00	SPY	ETF	148.22	148.2299	147.87	148.04	4872600.0
2007-12-27 15:00:00	SPY	ETF	148.04	148.27	147.92	147.93	4276905.0
2007-12-27 15:30:00	SPY	ETF	147.93	147.93	147.32	147.52	15515860.0
2007-12-27 16:00:00	SPY	ETF	147.55	149.06	147.39	147.8	3936200.0
2007-12-27 16:30:00	SPY	ETF	147.75	147.91	147.74	147.81	3361578.0
2007-12-27 17:00:00	SPY	ETF	147.82	147.88	147.8	147.84	16100.0
2007-12-27 17:30:00	SPY	ETF	147.8	149.53	147.78	147.9	4033400.0
2007-12-27 18:00:00	SPY	ETF	147.82	147.83	147.77	147.79	1700.0
2007-12-27 18:30:00	SPY	ETF	147.81	148.01	147.8	147.97	28900.0
2007-12-27 19:00:00	SPY	ETF	148.0	148.01	147.83	147.83	18300.0
2007-12-27 19:30:00	SPY	ETF	147.81	147.99	147.77	147.88	18300.0
2007-12-27 04:00:00	QQQ	ETF	52.48	52.48	52.48	52.48	200.0
2007-12-27 06:00:00	QQQ	ETF	52.63	52.63	52.63	52.63	100.0
2007-12-27 07:00:00	QQQ	ETF	52.66	52.68	52.59	52.67	90700.0
2007-12-27 07:30:00	QQQ	ETF	52.67	52.71	52.63	52.65	271600.0
2007-12-27 08:00:00	QQQ	ETF	52.67	52.67	52.43	52.47	1139159.0
2007-12-27 08:30:00	QQQ	ETF	52.47	52.74	52.3	52.41	1190655.0
2007-12-27 09:00:00	QQQ	ETF	52.43	52.43	52.35	52.35	354829.0
2007-12-27 09:30:00	QQQ	ETF	52.34	52.45	52.25	52.26	7749860.0
2007-12-27 10:00:00	QQQ	ETF	52.26	52.5	52.25	52.4595	4271349.0
2007-12-27 10:30:00	QQQ	ETF	52.45	52.48	52.27	52.27	3974886.0
2007-12-27 11:00:00	QQQ	ETF	52.27	52.301	52.08	52.23	4230143.0
2007-12-27 11:30:00	QQQ	ETF	52.24	52.27	52.16	52.2605	1679490.0
2007-12-27 12:00:00	QQQ	ETF	52.26	52.27	52.1	52.1	3373457.0
2007-12-27 12:30:00	QQQ	ETF	52.1	52.12	51.98	52.08	4020597.0
2007-12-27 13:00:00	QQQ	ETF	52.08	52.21	51.98	52.19	3705587.0
2007-12-27 13:30:00	QQQ	ETF	52.19	52.2	52.11	52.141	2905988.0
2007-12-27 14:00:00	QQQ	ETF	52.13	52.25	52.12	52.21	3681546.0
2007-12-27 14:30:00	QQQ	ETF	52.2	52.2099	52.03	52.07	3010491.0
2007-12-27 15:00:00	QQQ	ETF	52.06	52.13	51.94	51.95	3725905.0
2007-12-27 15:30:00	QQQ	ETF	51.95	51.95	51.71	51.84	9953997.0
2007-12-27 16:00:00	QQQ	ETF	51.85	51.94	51.73	51.87	4391562.0
2007-12-27 16:30:00	QQQ	ETF	51.87	51.92	51.85	51.85	2028014.0
2007-12-27 17:00:00	QQQ	ETF	51.87	51.88	51.84	51.85	12362.0

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

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