PREVIEW / etf_30min / 2008-04-30

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-30.parquet
  size:    167 KB
  rows:    5,785

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-04-30 04:30:00	SPY	ETF	139.11	139.11	139.11	139.11	800.0
2008-04-30 06:00:00	SPY	ETF	138.8	138.8	138.53	138.53	104300.0
2008-04-30 06:30:00	SPY	ETF	138.69	138.8	138.69	138.8	58100.0
2008-04-30 07:00:00	SPY	ETF	138.8	139.03	138.71	138.85	393934.0
2008-04-30 07:30:00	SPY	ETF	138.9	138.94	138.74	138.77	124042.0
2008-04-30 08:00:00	SPY	ETF	138.76	139.24	138.75	139.17	3442922.0
2008-04-30 08:30:00	SPY	ETF	139.2	139.65	139.2	139.45	3629939.0
2008-04-30 09:00:00	SPY	ETF	139.48	139.48	139.24	139.29	943702.0
2008-04-30 09:30:00	SPY	ETF	139.29	139.69	139.24	139.43	9348759.0
2008-04-30 10:00:00	SPY	ETF	139.43	139.59	139.27	139.41	7107081.0
2008-04-30 10:30:00	SPY	ETF	139.4	139.66	139.4	139.53	6249562.0
2008-04-30 11:00:00	SPY	ETF	139.52	139.93	139.52	139.81	9421555.0
2008-04-30 11:30:00	SPY	ETF	139.81	139.86	139.6	139.81	6052108.0
2008-04-30 12:00:00	SPY	ETF	139.8	139.86	139.47	139.48	7395042.0
2008-04-30 12:30:00	SPY	ETF	139.48	139.59	139.43	139.53	5352365.0
2008-04-30 13:00:00	SPY	ETF	139.53	139.76	139.5	139.7	6492655.0
2008-04-30 13:30:00	SPY	ETF	139.7	139.81	139.53	139.59	7260694.0
2008-04-30 14:00:00	SPY	ETF	139.59	140.59	139.36	140.08	38981691.0
2008-04-30 14:30:00	SPY	ETF	140.07	140.3	139.17	139.1799	25828203.0
2008-04-30 15:00:00	SPY	ETF	139.17	139.28	138.36	138.53	30932332.0
2008-04-30 15:30:00	SPY	ETF	138.53	138.97	138.35	138.43	25975121.0
2008-04-30 16:00:00	SPY	ETF	138.4799	138.9	138.27	138.3	6427110.0
2008-04-30 16:30:00	SPY	ETF	138.32	139.57	138.22	138.35	3655259.0
2008-04-30 17:00:00	SPY	ETF	138.36	138.45	138.36	138.43	173901.0
2008-04-30 17:30:00	SPY	ETF	138.43	138.5	138.43	138.44	22347.0
2008-04-30 18:00:00	SPY	ETF	138.45	138.55	138.45	138.51	15953.0
2008-04-30 18:30:00	SPY	ETF	138.52	138.56	138.5	138.5	23150.0
2008-04-30 19:00:00	SPY	ETF	138.48	138.53	138.48	138.53	12353.0
2008-04-30 19:30:00	SPY	ETF	138.54	138.57	138.5	138.55	6707.0
2008-04-30 04:30:00	QQQ	ETF	47.59	47.59	47.59	47.59	5000.0
2008-04-30 06:00:00	QQQ	ETF	47.55	47.55	47.48	47.48	15391.0
2008-04-30 06:30:00	QQQ	ETF	47.43	47.5	47.43	47.5	1000.0
2008-04-30 07:00:00	QQQ	ETF	47.48	47.58	47.48	47.5	281400.0
2008-04-30 07:30:00	QQQ	ETF	47.52	47.54	47.45	47.47	238152.0
2008-04-30 08:00:00	QQQ	ETF	47.47	47.73	47.46	47.6	935118.0
2008-04-30 08:30:00	QQQ	ETF	47.59	47.8	47.59	47.71	1509746.0
2008-04-30 09:00:00	QQQ	ETF	47.71	47.72	47.67	47.69	207208.0
2008-04-30 09:30:00	QQQ	ETF	47.68	47.79	47.6	47.719	7850560.0
2008-04-30 10:00:00	QQQ	ETF	47.7	47.75	47.65	47.712	4889356.0
2008-04-30 10:30:00	QQQ	ETF	47.72	47.87	47.72	47.82	5356413.0
2008-04-30 11:00:00	QQQ	ETF	47.82	47.94	47.81	47.93	4921211.0
2008-04-30 11:30:00	QQQ	ETF	47.94	47.96	47.79	47.87	6659216.0
2008-04-30 12:00:00	QQQ	ETF	47.87	47.89	47.73	47.75	3890294.0
2008-04-30 12:30:00	QQQ	ETF	47.75	47.84	47.73	47.81	2847796.0
2008-04-30 13:00:00	QQQ	ETF	47.8	47.88	47.75	47.83	1824815.0
2008-04-30 13:30:00	QQQ	ETF	47.83	47.84	47.7	47.74	3920209.0
2008-04-30 14:00:00	QQQ	ETF	47.74	48.06	47.63	47.85	19751814.0
2008-04-30 14:30:00	QQQ	ETF	47.85	47.94	47.35	47.36	18273744.0
2008-04-30 15:00:00	QQQ	ETF	47.36	47.3789	47.03	47.082	25793049.0
2008-04-30 15:30:00	QQQ	ETF	47.09	47.32	47.0802	47.21	15826064.0

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

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