PREVIEW / etf_30min / 2008-06-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-03.parquet
  size:    172 KB
  rows:    5,927

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-06-03 04:00:00	SPY	ETF	138.8	138.8	138.8	138.8	100.0
2008-06-03 05:00:00	SPY	ETF	138.99	138.99	138.99	138.99	300.0
2008-06-03 05:30:00	SPY	ETF	139.07	139.07	139.07	139.07	100.0
2008-06-03 06:00:00	SPY	ETF	139.12	139.12	138.93	138.93	69000.0
2008-06-03 06:30:00	SPY	ETF	138.88	138.89	138.73	138.89	13500.0
2008-06-03 07:00:00	SPY	ETF	138.76	139.08	138.76	139.03	458614.0
2008-06-03 07:30:00	SPY	ETF	139.01	139.18	138.94	139.18	132060.0
2008-06-03 08:00:00	SPY	ETF	139.16	139.31	138.45	139.26	655373.0
2008-06-03 08:30:00	SPY	ETF	139.26	139.37	139.14	139.15	659301.0
2008-06-03 09:00:00	SPY	ETF	139.15	139.41	138.9	139.33	1255558.0
2008-06-03 09:30:00	SPY	ETF	139.3	139.33	138.77	138.96	16270920.0
2008-06-03 10:00:00	SPY	ETF	138.96	139.6	138.96	139.09	21961230.0
2008-06-03 10:30:00	SPY	ETF	139.09	139.37	138.94	139.31	11391114.0
2008-06-03 11:00:00	SPY	ETF	139.31	139.5	139.18	139.42	10315347.0
2008-06-03 11:30:00	SPY	ETF	139.42	139.6	139.25	139.57	10151319.0
2008-06-03 12:00:00	SPY	ETF	139.575	139.62	139.18	139.22	8359112.0
2008-06-03 12:30:00	SPY	ETF	139.22	139.26	138.98	139.06	6787381.0
2008-06-03 13:00:00	SPY	ETF	139.06	139.17	138.72	138.75	13347863.0
2008-06-03 13:30:00	SPY	ETF	138.76	138.77	137.54	137.8895	35600920.0
2008-06-03 14:00:00	SPY	ETF	137.89	137.97	137.23	137.4	24723860.0
2008-06-03 14:30:00	SPY	ETF	137.4	137.8	137.33	137.77	24324654.0
2008-06-03 15:00:00	SPY	ETF	137.77	138.38	137.58	138.35	43112069.0
2008-06-03 15:30:00	SPY	ETF	138.36	138.63	137.98	138.05	28756935.0
2008-06-03 16:00:00	SPY	ETF	138.0299	138.8487	137.0	138.155	7206921.0
2008-06-03 16:30:00	SPY	ETF	138.12	138.85	138.02	138.06	4734565.0
2008-06-03 17:00:00	SPY	ETF	138.05	138.09	138.02	138.09	28282.0
2008-06-03 17:30:00	SPY	ETF	138.08	138.12	138.08	138.11	7900.0
2008-06-03 18:00:00	SPY	ETF	138.1	138.1	138.02	138.09	29930.0
2008-06-03 18:30:00	SPY	ETF	138.03	138.03	137.91	137.91	19513.0
2008-06-03 19:00:00	SPY	ETF	137.91	137.92	137.85	137.85	11775.0
2008-06-03 19:30:00	SPY	ETF	137.89	138.04	137.86	138.04	15166.0
2008-06-03 04:00:00	QQQ	ETF	49.4	49.4	49.4	49.4	100.0
2008-06-03 05:00:00	QQQ	ETF	49.44	49.44	49.44	49.44	950.0
2008-06-03 05:30:00	QQQ	ETF	49.5	49.5	49.5	49.5	100.0
2008-06-03 06:00:00	QQQ	ETF	49.54	49.56	49.54	49.56	1000.0
2008-06-03 06:30:00	QQQ	ETF	49.46	49.49	49.46	49.49	1100.0
2008-06-03 07:00:00	QQQ	ETF	49.41	49.53	49.41	49.53	15900.0
2008-06-03 07:30:00	QQQ	ETF	49.53	49.54	49.48	49.54	93214.0
2008-06-03 08:00:00	QQQ	ETF	49.54	49.61	49.5	49.58	260193.0
2008-06-03 08:30:00	QQQ	ETF	49.61	49.62	49.5	49.5	399223.0
2008-06-03 09:00:00	QQQ	ETF	49.51	49.6	49.5	49.58	590527.0
2008-06-03 09:30:00	QQQ	ETF	49.58	49.61	49.44	49.56	12075952.0
2008-06-03 10:00:00	QQQ	ETF	49.57	49.9	49.57	49.63	14490907.0
2008-06-03 10:30:00	QQQ	ETF	49.63	49.76	49.57	49.72	5431033.0
2008-06-03 11:00:00	QQQ	ETF	49.73	49.88	49.72	49.781	6843726.0
2008-06-03 11:30:00	QQQ	ETF	49.78	49.83	49.71	49.82	3364170.0
2008-06-03 12:00:00	QQQ	ETF	49.82	49.83	49.61	49.63	3383722.0
2008-06-03 12:30:00	QQQ	ETF	49.63	49.67	49.54	49.58	5855676.0
2008-06-03 13:00:00	QQQ	ETF	49.58	49.64	49.44	49.48	7971792.0
2008-06-03 13:30:00	QQQ	ETF	49.47	49.47	48.87	49.0101	23499103.0

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

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