PREVIEW / etf_30min / 2007-11-30

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-11-30.parquet
  size:    143 KB
  rows:    5,272

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-30 04:00:00	SPY	ETF	148.01	148.01	148.01	148.01	500.0
2007-11-30 05:30:00	SPY	ETF	148.15	148.15	148.01	148.01	3000.0
2007-11-30 06:00:00	SPY	ETF	148.03	148.2	148.03	148.2	10300.0
2007-11-30 06:30:00	SPY	ETF	148.25	148.39	148.08	148.33	90000.0
2007-11-30 07:00:00	SPY	ETF	148.3	149.0	148.25	148.83	1249200.0
2007-11-30 07:30:00	SPY	ETF	148.83	148.98	148.56	148.65	721000.0
2007-11-30 08:00:00	SPY	ETF	148.64	148.91	147.12	148.72	3541200.0
2007-11-30 08:30:00	SPY	ETF	148.72	149.04	148.62	148.84	1980000.0
2007-11-30 09:00:00	SPY	ETF	148.84	149.16	148.2	149.05	2748090.0
2007-11-30 09:30:00	SPY	ETF	149.04	149.87	148.62	148.89	30649604.0
2007-11-30 10:00:00	SPY	ETF	148.89	149.13	148.54	148.78	19584568.0
2007-11-30 10:30:00	SPY	ETF	148.78	149.02	148.5	148.67	12060540.0
2007-11-30 11:00:00	SPY	ETF	148.67	148.71	147.91	148.24	28561139.0
2007-11-30 11:30:00	SPY	ETF	148.26	149.13	147.99	148.47	9537979.0
2007-11-30 12:00:00	SPY	ETF	148.46	148.54	147.9	148.22	8435100.0
2007-11-30 12:30:00	SPY	ETF	148.22	148.41	148.01	148.34	6088509.0
2007-11-30 13:00:00	SPY	ETF	148.33	148.66	148.06	148.6	7074275.0
2007-11-30 13:30:00	SPY	ETF	148.61	148.8	148.47	148.56	6306370.0
2007-11-30 14:00:00	SPY	ETF	148.56	148.6	148.15	148.29	8340742.0
2007-11-30 14:30:00	SPY	ETF	148.28	148.53	148.01	148.15	8693810.0
2007-11-30 15:00:00	SPY	ETF	148.15	148.18	147.33	147.93	24578360.0
2007-11-30 15:30:00	SPY	ETF	147.94	148.49	147.63	148.44	28605811.0
2007-11-30 16:00:00	SPY	ETF	148.441	148.66	148.35	148.6	5047900.0
2007-11-30 16:30:00	SPY	ETF	148.6	148.67	148.4069	148.59	3048800.0
2007-11-30 17:00:00	SPY	ETF	148.57	148.57	148.47	148.48	45100.0
2007-11-30 17:30:00	SPY	ETF	148.49	148.54	148.47	148.5	15700.0
2007-11-30 18:00:00	SPY	ETF	148.6	148.6	148.55	148.55	200.0
2007-11-30 18:30:00	SPY	ETF	148.55	148.7	148.55	148.58	12300.0
2007-11-30 19:00:00	SPY	ETF	148.58	148.58	148.55	148.55	8500.0
2007-11-30 19:30:00	SPY	ETF	148.58	148.58	148.53	148.53	10700.0
2007-11-30 05:00:00	QQQ	ETF	51.9	51.9	51.9	51.9	200.0
2007-11-30 05:30:00	QQQ	ETF	51.91	51.91	51.91	51.91	10000.0
2007-11-30 06:00:00	QQQ	ETF	51.9	52.02	51.9	52.02	47600.0
2007-11-30 06:30:00	QQQ	ETF	52.0	52.05	51.99	52.05	179950.0
2007-11-30 07:00:00	QQQ	ETF	52.05	52.23	52.02	52.21	825323.0
2007-11-30 07:30:00	QQQ	ETF	52.17	52.25	52.05	52.07	869343.0
2007-11-30 08:00:00	QQQ	ETF	52.08	52.19	51.7	52.13	1174167.0
2007-11-30 08:30:00	QQQ	ETF	52.14	52.2	52.07	52.15	846743.0
2007-11-30 09:00:00	QQQ	ETF	52.15	52.26	52.14	52.2	1269390.0
2007-11-30 09:30:00	QQQ	ETF	52.21	52.25	51.92	52.06	22227512.0
2007-11-30 10:00:00	QQQ	ETF	52.06	52.115	51.72	51.89	16297578.0
2007-11-30 10:30:00	QQQ	ETF	51.89	51.96	51.72	51.79	9503041.0
2007-11-30 11:00:00	QQQ	ETF	51.79	51.79	51.35	51.48	21240539.0
2007-11-30 11:30:00	QQQ	ETF	51.47	51.62	51.34	51.6	9145427.0
2007-11-30 12:00:00	QQQ	ETF	51.6	51.61	51.27	51.4	7073789.0
2007-11-30 12:30:00	QQQ	ETF	51.4	51.53	51.36	51.52	6093526.0
2007-11-30 13:00:00	QQQ	ETF	51.52	51.54	51.31	51.52	8030727.0
2007-11-30 13:30:00	QQQ	ETF	51.51	51.59	51.48	51.5	4919777.0
2007-11-30 14:00:00	QQQ	ETF	51.5	51.56	51.36	51.48	5821047.0
2007-11-30 14:30:00	QQQ	ETF	51.4802	51.55	51.31	51.38	10343492.0

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

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