PREVIEW / etf_30min / 2007-01-29

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-29.parquet
  size:    96 KB
  rows:    3,354

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-01-29 07:00:00	SPY	ETF	142.05	142.22	142.05	142.22	39300.0
2007-01-29 07:30:00	SPY	ETF	142.21	142.24	142.15	142.15	236100.0
2007-01-29 08:00:00	SPY	ETF	142.17	142.25	142.08	142.09	736000.0
2007-01-29 08:30:00	SPY	ETF	142.06	142.15	142.05	142.13	256700.0
2007-01-29 09:00:00	SPY	ETF	142.14	142.17	142.1	142.16	118100.0
2007-01-29 09:30:00	SPY	ETF	142.19	142.49	142.08	142.37	5757000.0
2007-01-29 10:00:00	SPY	ETF	142.37	142.55	142.18	142.19	5937900.0
2007-01-29 10:30:00	SPY	ETF	142.19	142.34	142.1	142.25	5223600.0
2007-01-29 11:00:00	SPY	ETF	142.24	142.8	142.11	142.33	3530800.0
2007-01-29 11:30:00	SPY	ETF	142.33	142.33	142.15	142.24	1505600.0
2007-01-29 12:00:00	SPY	ETF	142.24	142.54	142.2	142.39	3056000.0
2007-01-29 12:30:00	SPY	ETF	142.38	142.59	142.36	142.55	2804600.0
2007-01-29 13:00:00	SPY	ETF	142.56	142.63	142.4	142.45	2157900.0
2007-01-29 13:30:00	SPY	ETF	142.45	142.49	142.01	142.04	8486100.0
2007-01-29 14:00:00	SPY	ETF	142.05	142.06	141.74	141.92	6478800.0
2007-01-29 14:30:00	SPY	ETF	141.91	142.05	141.85	141.88	3721800.0
2007-01-29 15:00:00	SPY	ETF	141.88	142.13	141.84	142.05	5670100.0
2007-01-29 15:30:00	SPY	ETF	142.05	142.1	141.96	141.96	4660300.0
2007-01-29 16:00:00	SPY	ETF	141.99	142.05	141.91	142.0	552600.0
2007-01-29 16:30:00	SPY	ETF	141.99	142.04	141.99	142.0	44600.0
2007-01-29 17:00:00	SPY	ETF	142.0	142.0	142.0	142.0	400.0
2007-01-29 17:30:00	SPY	ETF	142.0	142.148	141.98	142.148	2815900.0
2007-01-29 18:00:00	SPY	ETF	142.01	142.04	142.0	142.04	101400.0
2007-01-29 18:30:00	SPY	ETF	142.01	142.01	142.01	142.01	500.0
2007-01-29 19:30:00	SPY	ETF	142.02	142.05	142.02	142.05	200.0
2007-01-29 05:00:00	QQQ	ETF	43.4	43.4	43.4	43.4	200.0
2007-01-29 07:00:00	QQQ	ETF	43.41	43.5	43.41	43.5	275100.0
2007-01-29 07:30:00	QQQ	ETF	43.5	43.5	43.46	43.46	137290.0
2007-01-29 08:00:00	QQQ	ETF	43.47	43.48	43.45	43.45	477619.0
2007-01-29 08:30:00	QQQ	ETF	43.45	43.48	43.45	43.47	455544.0
2007-01-29 09:00:00	QQQ	ETF	43.47	43.48	43.43	43.46	601247.0
2007-01-29 09:30:00	QQQ	ETF	43.45	43.64	43.44	43.52	14550800.0
2007-01-29 10:00:00	QQQ	ETF	43.52	43.67	43.46	43.48	11844900.0
2007-01-29 10:30:00	QQQ	ETF	43.47	43.59	43.4	43.55	12116500.0
2007-01-29 11:00:00	QQQ	ETF	43.55	43.61	43.49	43.61	5676100.0
2007-01-29 11:30:00	QQQ	ETF	43.6	43.62	43.54	43.59	2857100.0
2007-01-29 12:00:00	QQQ	ETF	43.59	43.68	43.55	43.62	2414800.0
2007-01-29 12:30:00	QQQ	ETF	43.62	43.87	43.61	43.86	6716600.0
2007-01-29 13:00:00	QQQ	ETF	43.85	43.91	43.73	43.76	5493200.0
2007-01-29 13:30:00	QQQ	ETF	43.76	43.8	43.5	43.51	8724900.0
2007-01-29 14:00:00	QQQ	ETF	43.51	43.56	43.4	43.48	12471300.0
2007-01-29 14:30:00	QQQ	ETF	43.48	43.55	43.47	43.49	3633100.0
2007-01-29 15:00:00	QQQ	ETF	43.49	43.6	43.48	43.57	3938000.0
2007-01-29 15:30:00	QQQ	ETF	43.58	43.62	43.54	43.61	5437900.0
2007-01-29 16:00:00	QQQ	ETF	43.62	43.65	43.58	43.64	3007865.0
2007-01-29 16:30:00	QQQ	ETF	43.64	43.67	43.61	43.61	527112.0
2007-01-29 17:00:00	QQQ	ETF	43.64	43.65	43.61	43.64	25270.0
2007-01-29 17:30:00	QQQ	ETF	43.65	43.65	43.62	43.63	5710.0
2007-01-29 18:00:00	QQQ	ETF	43.63	43.66	43.63	43.66	5384.0
2007-01-29 18:30:00	QQQ	ETF	43.65	43.66	43.65	43.66	4970.0

> showing 50 of 3,354 rows — these rows as CSV

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