PREVIEW / etf_30min / 2008-07-09

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-09.parquet
  size:    173 KB
  rows:    5,916

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-09 04:00:00	SPY	ETF	126.8	126.8	126.8	126.8	100.0
2008-07-09 05:30:00	SPY	ETF	126.93	127.1	126.9	127.1	27000.0
2008-07-09 06:00:00	SPY	ETF	127.1	127.1	127.01	127.01	3000.0
2008-07-09 06:30:00	SPY	ETF	126.96	126.96	126.77	126.92	172300.0
2008-07-09 07:00:00	SPY	ETF	126.94	127.33	126.79	127.33	918314.0
2008-07-09 07:30:00	SPY	ETF	127.22	127.58	127.12	127.51	2216303.0
2008-07-09 08:00:00	SPY	ETF	127.53	127.71	126.95	127.69	4559983.0
2008-07-09 08:30:00	SPY	ETF	127.66	127.75	127.62	127.62	1560888.0
2008-07-09 09:00:00	SPY	ETF	127.63	127.64	127.4	127.51	3204282.0
2008-07-09 09:30:00	SPY	ETF	127.5	127.74	126.92	127.16	35226485.0
2008-07-09 10:00:00	SPY	ETF	127.16	127.63	126.79	127.55	31302194.0
2008-07-09 10:30:00	SPY	ETF	127.55	127.62	127.05	127.45	33470619.0
2008-07-09 11:00:00	SPY	ETF	127.45	127.74	127.19	127.67	22518751.0
2008-07-09 11:30:00	SPY	ETF	127.69	127.7	127.06	127.23	15227680.0
2008-07-09 12:00:00	SPY	ETF	127.232	127.39	126.94	127.13	12849683.0
2008-07-09 12:30:00	SPY	ETF	127.14	127.2	126.7	126.78	12000901.0
2008-07-09 13:00:00	SPY	ETF	126.78	126.82	126.39	126.67	15100068.0
2008-07-09 13:30:00	SPY	ETF	126.66	126.89	126.51	126.61	12111026.0
2008-07-09 14:00:00	SPY	ETF	126.6	126.69	126.15	126.29	24849162.0
2008-07-09 14:30:00	SPY	ETF	126.29	127.3346	125.53	125.64	26968664.0
2008-07-09 15:00:00	SPY	ETF	125.65	125.67	125.25	125.52	29030260.0
2008-07-09 15:30:00	SPY	ETF	125.52	125.67	124.39	124.45	37149826.0
2008-07-09 16:00:00	SPY	ETF	124.468	125.15	124.46	124.69	5176679.0
2008-07-09 16:30:00	SPY	ETF	124.74	127.3346	124.44	124.5	4320514.0
2008-07-09 17:00:00	SPY	ETF	124.45	124.5	124.4	124.44	113909.0
2008-07-09 17:30:00	SPY	ETF	125.46	126.5292	124.39	124.39	179800.0
2008-07-09 18:00:00	SPY	ETF	124.4	124.47	124.37	124.4	81374.0
2008-07-09 18:30:00	SPY	ETF	124.42	124.45	124.38	124.41	3764.0
2008-07-09 19:00:00	SPY	ETF	124.42	124.47	124.38	124.46	34740.0
2008-07-09 19:30:00	SPY	ETF	124.47	124.47	124.42	124.45	22563.0
2008-07-09 04:00:00	QQQ	ETF	45.66	45.67	45.66	45.67	10000.0
2008-07-09 05:00:00	QQQ	ETF	45.74	45.74	45.74	45.74	5000.0
2008-07-09 06:00:00	QQQ	ETF	45.8	45.8	45.8	45.8	2000.0
2008-07-09 07:00:00	QQQ	ETF	45.77	45.87	45.68	45.86	120755.0
2008-07-09 07:30:00	QQQ	ETF	45.86	45.97	45.86	45.97	446648.0
2008-07-09 08:00:00	QQQ	ETF	45.97	46.03	45.96	45.99	1191085.0
2008-07-09 08:30:00	QQQ	ETF	45.99	46.0	45.95	45.95	634818.0
2008-07-09 09:00:00	QQQ	ETF	45.94	45.98	45.88	45.96	1042821.0
2008-07-09 09:30:00	QQQ	ETF	45.96	45.97	45.58	45.72	18961111.0
2008-07-09 10:00:00	QQQ	ETF	45.72	45.94	45.58	45.88	12057721.0
2008-07-09 10:30:00	QQQ	ETF	45.8801	45.92	45.64	45.85	12378419.0
2008-07-09 11:00:00	QQQ	ETF	45.8499	46.03	45.79	46.0095	12065011.0
2008-07-09 11:30:00	QQQ	ETF	46.01	46.02	45.73	45.78	8541230.0
2008-07-09 12:00:00	QQQ	ETF	45.78	45.81	45.64	45.75	8008265.0
2008-07-09 12:30:00	QQQ	ETF	45.75	45.77	45.54	45.64	8295440.0
2008-07-09 13:00:00	QQQ	ETF	45.63	45.6401	45.45	45.62	7025908.0
2008-07-09 13:30:00	QQQ	ETF	45.62	45.7	45.53	45.63	4547252.0
2008-07-09 14:00:00	QQQ	ETF	45.63	45.74	45.5	45.61	9884374.0
2008-07-09 14:30:00	QQQ	ETF	45.61	45.68	45.25	45.35	11893005.0
2008-07-09 15:00:00	QQQ	ETF	45.34	45.34	45.1	45.17	12370637.0

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

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