PREVIEW / etf_30min / 2008-07-25

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-25.parquet
  size:    166 KB
  rows:    5,868

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
2008-07-25 04:00:00	SPY	ETF	125.59	125.59	125.59	125.59	100.0
2008-07-25 04:30:00	SPY	ETF	125.5	125.5	125.48	125.48	300.0
2008-07-25 05:00:00	SPY	ETF	125.4	125.4	125.11	125.11	500.0
2008-07-25 05:30:00	SPY	ETF	125.27	125.27	125.26	125.26	10000.0
2008-07-25 06:00:00	SPY	ETF	125.28	125.28	125.28	125.28	100.0
2008-07-25 06:30:00	SPY	ETF	125.4	125.5	125.3	125.3	9200.0
2008-07-25 07:00:00	SPY	ETF	125.27	125.35	125.24	125.32	72100.0
2008-07-25 07:30:00	SPY	ETF	125.32	125.76	125.32	125.65	334099.0
2008-07-25 08:00:00	SPY	ETF	125.66	125.67	125.25	125.6	1274354.0
2008-07-25 08:30:00	SPY	ETF	125.7	126.1	125.6	125.79	4334936.0
2008-07-25 09:00:00	SPY	ETF	125.8	125.95	125.64	125.88	2084383.0
2008-07-25 09:30:00	SPY	ETF	125.89	126.06	125.28	125.99	28178566.0
2008-07-25 10:00:00	SPY	ETF	125.99	126.33	125.57	125.58	30901234.0
2008-07-25 10:30:00	SPY	ETF	125.58	126.49	125.5	126.269	17345543.0
2008-07-25 11:00:00	SPY	ETF	126.27	126.3	125.76	125.87	10391361.0
2008-07-25 11:30:00	SPY	ETF	125.87	126.18	125.81	125.87	10752426.0
2008-07-25 12:00:00	SPY	ETF	125.87	125.95	125.59	125.79	8096115.0
2008-07-25 12:30:00	SPY	ETF	125.78	125.99	125.66	125.94	5600568.0
2008-07-25 13:00:00	SPY	ETF	125.94	126.1	125.4	125.52	17729529.0
2008-07-25 13:30:00	SPY	ETF	125.52	125.65	125.17	125.51	12546232.0
2008-07-25 14:00:00	SPY	ETF	125.51	125.89	125.47	125.54	12557419.0
2008-07-25 14:30:00	SPY	ETF	125.54	125.93	125.5	125.84	7936690.0
2008-07-25 15:00:00	SPY	ETF	125.84	125.89	125.38	125.43	10444261.0
2008-07-25 15:30:00	SPY	ETF	125.43	125.9	125.27	125.71	22320633.0
2008-07-25 16:00:00	SPY	ETF	125.64	125.79	125.27	125.45	10419597.0
2008-07-25 16:30:00	SPY	ETF	125.45	125.49	125.38	125.45	110538.0
2008-07-25 17:00:00	SPY	ETF	125.45	125.54	125.44	125.51	58600.0
2008-07-25 17:30:00	SPY	ETF	125.51	125.53	125.45	125.45	21843.0
2008-07-25 18:00:00	SPY	ETF	125.5	125.5	125.45	125.45	3400.0
2008-07-25 18:30:00	SPY	ETF	125.5	125.5	125.4	125.4	7029.0
2008-07-25 19:00:00	SPY	ETF	125.45	125.45	125.4	125.4	2350.0
2008-07-25 19:30:00	SPY	ETF	125.44	125.44	125.44	125.44	300.0
2008-07-25 04:30:00	QQQ	ETF	44.79	44.79	44.79	44.79	400.0
2008-07-25 07:00:00	QQQ	ETF	44.61	44.65	44.58	44.65	66934.0
2008-07-25 07:30:00	QQQ	ETF	44.67	44.85	44.67	44.84	124492.0
2008-07-25 08:00:00	QQQ	ETF	44.84	44.85	44.78	44.79	725963.0
2008-07-25 08:30:00	QQQ	ETF	44.8	44.99	44.8	44.9	1595082.0
2008-07-25 09:00:00	QQQ	ETF	44.9	45.01	44.85	44.98	1033427.0
2008-07-25 09:30:00	QQQ	ETF	44.98	45.1401	44.76	45.06	22167278.0
2008-07-25 10:00:00	QQQ	ETF	45.06	45.26	45.05	45.05	16515971.0
2008-07-25 10:30:00	QQQ	ETF	45.05	45.36	44.83	45.33	11444475.0
2008-07-25 11:00:00	QQQ	ETF	45.34	45.37	45.13	45.19	4167572.0
2008-07-25 11:30:00	QQQ	ETF	45.2	45.32	45.19	45.26	4739610.0
2008-07-25 12:00:00	QQQ	ETF	45.25	45.27	45.07	45.16	3557636.0
2008-07-25 12:30:00	QQQ	ETF	45.17	45.23	45.1199	45.22	2720854.0
2008-07-25 13:00:00	QQQ	ETF	45.22	45.31	45.1	45.16	6173614.0
2008-07-25 13:30:00	QQQ	ETF	45.16	45.24	45.07	45.19	4246269.0
2008-07-25 14:00:00	QQQ	ETF	45.1895	45.33	45.16	45.22	6103219.0
2008-07-25 14:30:00	QQQ	ETF	45.22	45.48	45.21	45.46	5449268.0
2008-07-25 15:00:00	QQQ	ETF	45.45	45.48	45.27	45.32	7082189.0

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

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