PREVIEW / etf_30min / 2008-02-14

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-14.parquet
  size:    154 KB
  rows:    5,532

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-14 04:00:00	SPY	ETF	136.75	136.75	136.75	136.75	100.0
2008-02-14 04:30:00	SPY	ETF	136.77	136.77	136.77	136.77	100.0
2008-02-14 05:00:00	SPY	ETF	136.54	136.54	136.52	136.52	1000.0
2008-02-14 05:30:00	SPY	ETF	136.67	136.79	136.67	136.74	15600.0
2008-02-14 06:00:00	SPY	ETF	136.67	136.67	136.67	136.67	200.0
2008-02-14 06:30:00	SPY	ETF	136.7	136.84	136.7	136.7	27100.0
2008-02-14 07:00:00	SPY	ETF	136.75	136.89	136.72	136.89	185600.0
2008-02-14 07:30:00	SPY	ETF	136.85	136.85	136.56	136.62	289600.0
2008-02-14 08:00:00	SPY	ETF	136.64	137.03	136.46	136.54	633700.0
2008-02-14 08:30:00	SPY	ETF	136.56	136.97	136.56	136.79	1740100.0
2008-02-14 09:00:00	SPY	ETF	136.8	137.04	136.75	136.95	2125070.0
2008-02-14 09:30:00	SPY	ETF	136.95	137.0	136.22	136.46	17776466.0
2008-02-14 10:00:00	SPY	ETF	136.46	136.98	136.2	136.7	13297147.0
2008-02-14 10:30:00	SPY	ETF	136.71	136.865	136.17	136.22	12339556.0
2008-02-14 11:00:00	SPY	ETF	136.22	136.3	135.55	135.87	19510600.0
2008-02-14 11:30:00	SPY	ETF	135.87	135.96	135.46	135.7799	13599121.0
2008-02-14 12:00:00	SPY	ETF	135.78	136.12	135.46	136.05	10487285.0
2008-02-14 12:30:00	SPY	ETF	136.07	136.07	135.51	135.52	14036574.0
2008-02-14 13:00:00	SPY	ETF	135.51	135.67	135.25	135.42	18313075.0
2008-02-14 13:30:00	SPY	ETF	135.4215	135.68	135.33	135.59	5887345.0
2008-02-14 14:00:00	SPY	ETF	135.5801	135.81	135.45	135.51	11739076.0
2008-02-14 14:30:00	SPY	ETF	135.525	135.61	134.79	135.33	17533570.0
2008-02-14 15:00:00	SPY	ETF	135.34	135.89	135.1	135.68	22278336.0
2008-02-14 15:30:00	SPY	ETF	135.69	135.75	134.9	135.01	26789808.0
2008-02-14 16:00:00	SPY	ETF	135.01	136.17	135.0	135.1	2576700.0
2008-02-14 16:30:00	SPY	ETF	135.11	135.17	135.05	135.07	443030.0
2008-02-14 17:00:00	SPY	ETF	135.1	135.19	135.03	135.07	120300.0
2008-02-14 17:30:00	SPY	ETF	135.09	135.14	135.01	135.13	879700.0
2008-02-14 18:00:00	SPY	ETF	135.08	135.15	135.03	135.03	28700.0
2008-02-14 18:30:00	SPY	ETF	135.06	135.06	134.88	134.95	25400.0
2008-02-14 19:00:00	SPY	ETF	134.9	135.05	134.86	135.05	9200.0
2008-02-14 19:30:00	SPY	ETF	134.95	134.97	134.83	134.93	32400.0
2008-02-14 05:30:00	QQQ	ETF	44.75	44.86	44.74	44.86	23000.0
2008-02-14 06:30:00	QQQ	ETF	44.86	44.86	44.86	44.86	100.0
2008-02-14 07:00:00	QQQ	ETF	44.9	44.91	44.88	44.91	5500.0
2008-02-14 07:30:00	QQQ	ETF	44.9	44.9	44.78	44.84	170696.0
2008-02-14 08:00:00	QQQ	ETF	44.84	44.87	44.82	44.86	609027.0
2008-02-14 08:30:00	QQQ	ETF	44.88	44.93	44.81	44.87	779282.0
2008-02-14 09:00:00	QQQ	ETF	44.9	44.92	44.82	44.85	664109.0
2008-02-14 09:30:00	QQQ	ETF	44.84	44.85	44.41	44.61	34048053.0
2008-02-14 10:00:00	QQQ	ETF	44.61	44.73	44.5	44.6599	10594325.0
2008-02-14 10:30:00	QQQ	ETF	44.66	44.71	44.45	44.45	6942545.0
2008-02-14 11:00:00	QQQ	ETF	44.46	44.52	44.21	44.33	11911544.0
2008-02-14 11:30:00	QQQ	ETF	44.33	44.36	44.19	44.28	8393792.0
2008-02-14 12:00:00	QQQ	ETF	44.29	44.4	44.15	44.3599	9658894.0
2008-02-14 12:30:00	QQQ	ETF	44.35	44.38	44.17	44.18	7756493.0
2008-02-14 13:00:00	QQQ	ETF	44.18	44.23	44.06	44.15	12875084.0
2008-02-14 13:30:00	QQQ	ETF	44.16	44.24	44.09	44.205	7475020.0
2008-02-14 14:00:00	QQQ	ETF	44.21	44.26	44.08	44.12	6558242.0
2008-02-14 14:30:00	QQQ	ETF	44.11	44.16	43.89	44.01	14694043.0

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

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