PREVIEW / etf_30min / 2010-08-23

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-08-23.parquet
  size:    251 KB
  rows:    8,279

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
2010-08-23 04:00:00	SPY	ETF	107.75	107.9	107.75	107.9	1000.0
2010-08-23 04:30:00	SPY	ETF	107.88	108.0	107.88	108.0	2000.0
2010-08-23 05:00:00	SPY	ETF	108.0	108.0	108.0	108.0	100.0
2010-08-23 05:30:00	SPY	ETF	108.0	108.07	108.0	108.07	5200.0
2010-08-23 06:00:00	SPY	ETF	108.12	108.13	108.12	108.13	1400.0
2010-08-23 06:30:00	SPY	ETF	108.13	108.22	108.13	108.2	1400.0
2010-08-23 07:00:00	SPY	ETF	108.17	108.2	108.08	108.12	27254.0
2010-08-23 07:30:00	SPY	ETF	108.12	108.27	108.08	108.23	141932.0
2010-08-23 08:00:00	SPY	ETF	108.25	108.28	108.03	108.05	852504.0
2010-08-23 08:30:00	SPY	ETF	108.09	108.13	107.96	107.98	263506.0
2010-08-23 09:00:00	SPY	ETF	107.98	108.1	107.88	108.04	728850.0
2010-08-23 09:30:00	SPY	ETF	108.04	108.57	107.9	108.37	22364833.0
2010-08-23 10:00:00	SPY	ETF	108.37	108.41	107.78	107.88	14633620.0
2010-08-23 10:30:00	SPY	ETF	107.88	108.06	107.42	107.59	17443864.0
2010-08-23 11:00:00	SPY	ETF	107.59	107.64	107.3	107.3999	10830758.0
2010-08-23 11:30:00	SPY	ETF	107.4	107.62	107.36	107.44	6377826.0
2010-08-23 12:00:00	SPY	ETF	107.44	107.72	107.42	107.68	5363333.0
2010-08-23 12:30:00	SPY	ETF	107.68	107.765	107.5	107.5799	4614794.0
2010-08-23 13:00:00	SPY	ETF	107.575	107.69	107.41	107.67	4350865.0
2010-08-23 13:30:00	SPY	ETF	107.665	107.7	107.44	107.63	4980374.0
2010-08-23 14:00:00	SPY	ETF	107.62	107.95	107.57	107.76	8174239.0
2010-08-23 14:30:00	SPY	ETF	107.75	107.92	107.66	107.69	5036137.0
2010-08-23 15:00:00	SPY	ETF	107.69	107.81	107.4	107.45	12861392.0
2010-08-23 15:30:00	SPY	ETF	107.445	107.47	107.07	107.12	25240916.0
2010-08-23 16:00:00	SPY	ETF	107.12	108.4	107.0	107.06	6881576.0
2010-08-23 16:30:00	SPY	ETF	107.08	107.5455	107.05	107.07	2454867.0
2010-08-23 17:00:00	SPY	ETF	107.08	107.13	107.07	107.09	2097859.0
2010-08-23 17:30:00	SPY	ETF	107.09	107.5455	107.04	107.05	2029406.0
2010-08-23 18:00:00	SPY	ETF	107.09	107.13	106.94	106.97	119191.0
2010-08-23 18:30:00	SPY	ETF	106.97	106.98	106.93	106.94	92868.0
2010-08-23 19:00:00	SPY	ETF	106.94	106.96	106.92	106.92	12545.0
2010-08-23 19:30:00	SPY	ETF	106.91	106.94	106.67	106.75	169888.0
2010-08-23 04:00:00	QQQ	ETF	45.0	45.05	45.0	45.05	200.0
2010-08-23 05:00:00	QQQ	ETF	45.17	45.17	45.17	45.17	500.0
2010-08-23 05:30:00	QQQ	ETF	45.13	45.14	45.13	45.13	2800.0
2010-08-23 06:00:00	QQQ	ETF	45.18	45.19	45.18	45.19	8000.0
2010-08-23 06:30:00	QQQ	ETF	45.2	45.2	45.2	45.2	2300.0
2010-08-23 07:00:00	QQQ	ETF	45.22	45.22	45.17	45.19	20800.0
2010-08-23 07:30:00	QQQ	ETF	45.2	45.26	45.18	45.24	24146.0
2010-08-23 08:00:00	QQQ	ETF	45.24	45.27	45.17	45.17	146359.0
2010-08-23 08:30:00	QQQ	ETF	45.19	45.19	45.13	45.13	85245.0
2010-08-23 09:00:00	QQQ	ETF	45.13	45.26	45.09	45.24	565216.0
2010-08-23 09:30:00	QQQ	ETF	45.25	45.34	45.1061	45.23	8296103.0
2010-08-23 10:00:00	QQQ	ETF	45.22	45.23	44.78	44.815	8068553.0
2010-08-23 10:30:00	QQQ	ETF	44.82	44.94	44.61	44.68	6514073.0
2010-08-23 11:00:00	QQQ	ETF	44.68	44.6999	44.53	44.5799	4989836.0
2010-08-23 11:30:00	QQQ	ETF	44.58	44.68	44.5601	44.62	1859472.0
2010-08-23 12:00:00	QQQ	ETF	44.6202	44.74	44.615	44.6925	2640336.0
2010-08-23 12:30:00	QQQ	ETF	44.7	44.75	44.61	44.6401	1336530.0
2010-08-23 13:00:00	QQQ	ETF	44.64	44.71	44.56	44.7	1376262.0

> showing 50 of 8,279 rows — these rows as CSV

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