PREVIEW / etf_30min / 2008-06-06

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-06-06.parquet
  size:    174 KB
  rows:    6,013

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-06 04:00:00	SPY	ETF	141.09	141.1	141.0	141.0	5850.0
2008-06-06 05:30:00	SPY	ETF	140.72	140.85	140.72	140.85	10100.0
2008-06-06 06:00:00	SPY	ETF	140.62	140.63	140.6	140.63	900.0
2008-06-06 06:30:00	SPY	ETF	140.63	140.9	140.58	140.9	9800.0
2008-06-06 07:00:00	SPY	ETF	141.0	141.0	140.63	140.74	21600.0
2008-06-06 07:30:00	SPY	ETF	140.69	140.87	140.66	140.85	191988.0
2008-06-06 08:00:00	SPY	ETF	140.6	141.22	140.6	141.09	2510804.0
2008-06-06 08:30:00	SPY	ETF	140.8	141.4	139.92	140.12	10870717.0
2008-06-06 09:00:00	SPY	ETF	140.11	140.11	139.47	139.55	3929743.0
2008-06-06 09:30:00	SPY	ETF	139.55	139.8	139.33	139.4	30604254.0
2008-06-06 10:00:00	SPY	ETF	139.41	139.42	138.56	138.72	36372352.0
2008-06-06 10:30:00	SPY	ETF	138.73	138.94	138.44	138.67	19235265.0
2008-06-06 11:00:00	SPY	ETF	138.67	138.68	137.93	137.98	23749803.0
2008-06-06 11:30:00	SPY	ETF	137.98	138.5	137.93	138.29	21130644.0
2008-06-06 12:00:00	SPY	ETF	138.29	138.4	138.03	138.09	14871514.0
2008-06-06 12:30:00	SPY	ETF	138.09	138.54	138.08	138.24	14009784.0
2008-06-06 13:00:00	SPY	ETF	138.25	138.31	137.78	138.05	19503773.0
2008-06-06 13:30:00	SPY	ETF	138.06	138.34	137.82	138.05	15241452.0
2008-06-06 14:00:00	SPY	ETF	138.04	138.055	137.15	137.545	31265654.0
2008-06-06 14:30:00	SPY	ETF	137.5101	137.72	137.18	137.19	20815956.0
2008-06-06 15:00:00	SPY	ETF	137.19	138.0	136.94	137.1	37795503.0
2008-06-06 15:30:00	SPY	ETF	137.105	137.81	136.34	136.38	51081136.0
2008-06-06 16:00:00	SPY	ETF	136.63	137.1	136.22	136.32	12047356.0
2008-06-06 16:30:00	SPY	ETF	136.33	136.48	136.32	136.46	6456756.0
2008-06-06 17:00:00	SPY	ETF	136.45	136.54	136.32	136.5	68996.0
2008-06-06 17:30:00	SPY	ETF	136.48	136.5	136.42	136.42	170953.0
2008-06-06 18:00:00	SPY	ETF	136.5	136.5	136.4	136.5	7407.0
2008-06-06 18:30:00	SPY	ETF	136.5	136.5	136.42	136.42	2957.0
2008-06-06 19:00:00	SPY	ETF	136.5	136.53	136.49	136.53	4883.0
2008-06-06 19:30:00	SPY	ETF	136.5	136.55	136.42	136.55	13244.0
2008-06-06 06:00:00	QQQ	ETF	50.5	50.53	50.5	50.53	1100.0
2008-06-06 06:30:00	QQQ	ETF	50.6	50.6	50.6	50.6	300.0
2008-06-06 07:00:00	QQQ	ETF	50.62	50.62	50.5	50.5	73500.0
2008-06-06 07:30:00	QQQ	ETF	50.51	50.59	50.49	50.59	161203.0
2008-06-06 08:00:00	QQQ	ETF	50.58	50.69	50.58	50.66	1198366.0
2008-06-06 08:30:00	QQQ	ETF	50.69	50.75	50.23	50.33	3712634.0
2008-06-06 09:00:00	QQQ	ETF	50.33	50.61	50.08	50.1	2553663.0
2008-06-06 09:30:00	QQQ	ETF	50.11	50.21	49.91	50.04	19356421.0
2008-06-06 10:00:00	QQQ	ETF	50.05	50.0599	49.81	49.88	18702212.0
2008-06-06 10:30:00	QQQ	ETF	49.88	49.94	49.77	49.81	10444970.0
2008-06-06 11:00:00	QQQ	ETF	49.81	49.82	49.55	49.57	12874574.0
2008-06-06 11:30:00	QQQ	ETF	49.57	49.74	49.55	49.6699	9835071.0
2008-06-06 12:00:00	QQQ	ETF	49.66	49.75	49.56	49.62	9129379.0
2008-06-06 12:30:00	QQQ	ETF	49.63	49.8	49.62	49.69	4606569.0
2008-06-06 13:00:00	QQQ	ETF	49.69	49.71	49.44	49.51	9200606.0
2008-06-06 13:30:00	QQQ	ETF	49.51	49.63	49.45	49.53	6285436.0
2008-06-06 14:00:00	QQQ	ETF	49.52	49.53	49.11	49.18	16747737.0
2008-06-06 14:30:00	QQQ	ETF	49.19	49.28	49.07	49.09	9523629.0
2008-06-06 15:00:00	QQQ	ETF	49.09	49.48	49.085	49.22	16947800.0
2008-06-06 15:30:00	QQQ	ETF	49.22	49.29	49.02	49.03	19970619.0

> showing 50 of 6,013 rows — these rows as CSV

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