PREVIEW / etf_30min / 2008-02-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-05.parquet
  size:    160 KB
  rows:    5,746

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-02-05 04:00:00	SPY	ETF	137.75	137.75	137.54	137.54	1500.0
2008-02-05 04:30:00	SPY	ETF	137.57	137.57	137.57	137.57	700.0
2008-02-05 05:30:00	SPY	ETF	137.67	137.67	137.65	137.65	50000.0
2008-02-05 06:00:00	SPY	ETF	137.71	137.71	137.58	137.58	2000.0
2008-02-05 06:30:00	SPY	ETF	137.61	137.64	137.51	137.64	30200.0
2008-02-05 07:00:00	SPY	ETF	137.57	137.57	137.34	137.35	627500.0
2008-02-05 07:30:00	SPY	ETF	137.3	137.3	137.05	137.13	1583600.0
2008-02-05 08:00:00	SPY	ETF	137.19	137.82	137.1	137.25	2044800.0
2008-02-05 08:30:00	SPY	ETF	137.22	137.32	135.66	135.7	11792022.0
2008-02-05 09:00:00	SPY	ETF	135.7	137.0736	135.56	135.85	6039410.0
2008-02-05 09:30:00	SPY	ETF	135.86	136.24	135.21	136.05	39223766.0
2008-02-05 10:00:00	SPY	ETF	136.05	136.15	135.42	136.13	22850361.0
2008-02-05 10:30:00	SPY	ETF	136.15	136.25	135.18	135.44	20338901.0
2008-02-05 11:00:00	SPY	ETF	135.44	135.75	134.88	135.24	13989866.0
2008-02-05 11:30:00	SPY	ETF	135.23	135.86	135.08	135.69	14039764.0
2008-02-05 12:00:00	SPY	ETF	135.7	135.74	134.86	135.1	11774301.0
2008-02-05 12:30:00	SPY	ETF	135.11	135.29	134.78	135.03	10901035.0
2008-02-05 13:00:00	SPY	ETF	135.02	135.37	134.55	134.76	13188200.0
2008-02-05 13:30:00	SPY	ETF	134.76	134.91	134.29	134.52	14666455.0
2008-02-05 14:00:00	SPY	ETF	134.52	134.85	134.09	134.74	12950055.0
2008-02-05 14:30:00	SPY	ETF	134.73	135.14	134.45	134.48	15166700.0
2008-02-05 15:00:00	SPY	ETF	134.48	134.5	133.88	134.17	19096764.0
2008-02-05 15:30:00	SPY	ETF	134.18	134.6	133.68	133.7	29926050.0
2008-02-05 16:00:00	SPY	ETF	133.71	134.9723	133.7	134.19	5339600.0
2008-02-05 16:30:00	SPY	ETF	134.19	135.0272	134.15	134.25	6349221.0
2008-02-05 17:00:00	SPY	ETF	134.25	134.41	134.15	134.25	10764000.0
2008-02-05 17:30:00	SPY	ETF	134.22	134.38	134.22	134.3	72200.0
2008-02-05 18:00:00	SPY	ETF	134.26	134.27	134.13	134.13	72500.0
2008-02-05 18:30:00	SPY	ETF	134.15	134.25	134.12	134.25	70600.0
2008-02-05 19:00:00	SPY	ETF	134.2	134.34	134.2	134.3	40700.0
2008-02-05 19:30:00	SPY	ETF	134.3	134.47	134.18	134.25	66500.0
2008-02-05 07:00:00	QQQ	ETF	44.8	44.8	44.73	44.73	17270.0
2008-02-05 07:30:00	QQQ	ETF	44.7	44.71	44.66	44.68	86802.0
2008-02-05 08:00:00	QQQ	ETF	44.67	44.76	44.67	44.74	189268.0
2008-02-05 08:30:00	QQQ	ETF	44.73	44.76	44.2	44.21	3850370.0
2008-02-05 09:00:00	QQQ	ETF	44.2	44.26	44.1	44.12	4206178.0
2008-02-05 09:30:00	QQQ	ETF	44.11	44.55	44.11	44.51	25093591.0
2008-02-05 10:00:00	QQQ	ETF	44.51	44.57	44.33	44.5699	15184140.0
2008-02-05 10:30:00	QQQ	ETF	44.57	44.6	44.23	44.33	10252406.0
2008-02-05 11:00:00	QQQ	ETF	44.33	44.35	44.2	44.27	7125651.0
2008-02-05 11:30:00	QQQ	ETF	44.28	44.45	44.24	44.39	7390824.0
2008-02-05 12:00:00	QQQ	ETF	44.39	44.4099	44.2	44.25	9600771.0
2008-02-05 12:30:00	QQQ	ETF	44.25	44.29	44.11	44.15	8740050.0
2008-02-05 13:00:00	QQQ	ETF	44.14	44.231	43.79	43.99	17679185.0
2008-02-05 13:30:00	QQQ	ETF	43.98	44.06	43.88	43.91	8955773.0
2008-02-05 14:00:00	QQQ	ETF	43.92	44.03	43.8	43.97	10775074.0
2008-02-05 14:30:00	QQQ	ETF	43.97	44.11	43.87	43.87	11214694.0
2008-02-05 15:00:00	QQQ	ETF	43.87	43.91	43.65	43.75	11030569.0
2008-02-05 15:30:00	QQQ	ETF	43.75	43.91	43.64	43.67	28961897.0
2008-02-05 16:00:00	QQQ	ETF	43.66	44.0937	43.62	43.76	6526938.0

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

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