PREVIEW / etf_30min / 2007-06-19

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-06-19.parquet
  size:    115 KB
  rows:    4,404

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
2007-06-19 06:30:00	SPY	ETF	152.76	152.76	152.76	152.76	2000.0
2007-06-19 07:00:00	SPY	ETF	152.84	152.88	152.77	152.8	63800.0
2007-06-19 07:30:00	SPY	ETF	152.78	152.82	152.72	152.81	249300.0
2007-06-19 08:00:00	SPY	ETF	152.72	152.81	152.48	152.58	990500.0
2007-06-19 08:30:00	SPY	ETF	152.58	152.7	152.52	152.56	1004000.0
2007-06-19 09:00:00	SPY	ETF	152.55	152.65	152.48	152.64	890500.0
2007-06-19 09:30:00	SPY	ETF	152.64	152.72	152.36	152.51	13002826.0
2007-06-19 10:00:00	SPY	ETF	152.52	152.77	152.39	152.7	7499280.0
2007-06-19 10:30:00	SPY	ETF	152.7	152.94	152.7	152.87	9206811.0
2007-06-19 11:00:00	SPY	ETF	152.86	152.88	152.62	152.66	4519260.0
2007-06-19 11:30:00	SPY	ETF	152.66	152.81	152.53	152.78	4956800.0
2007-06-19 12:00:00	SPY	ETF	152.79	153.27	152.79	153.1	9784842.0
2007-06-19 12:30:00	SPY	ETF	153.1	153.27	153.05	153.2	4656547.0
2007-06-19 13:00:00	SPY	ETF	153.2	153.38	153.07	153.12	4971894.0
2007-06-19 13:30:00	SPY	ETF	153.12	153.16	152.93	152.95	6047788.0
2007-06-19 14:00:00	SPY	ETF	152.95	153.07	152.79	152.88	7475000.0
2007-06-19 14:30:00	SPY	ETF	152.88	152.93	152.68	152.86	8799900.0
2007-06-19 15:00:00	SPY	ETF	152.86	153.17	152.77	153.07	7461294.0
2007-06-19 15:30:00	SPY	ETF	153.08	153.27	153.03	153.2	11810913.0
2007-06-19 16:00:00	SPY	ETF	153.23	153.28	153.09	153.19	2938400.0
2007-06-19 16:30:00	SPY	ETF	153.22	153.25	153.18	153.25	84800.0
2007-06-19 17:00:00	SPY	ETF	153.24	153.24	153.09	153.14	374800.0
2007-06-19 17:30:00	SPY	ETF	153.14	153.14	153.12	153.14	244900.0
2007-06-19 18:00:00	SPY	ETF	153.14	153.18	153.08	153.08	15700.0
2007-06-19 18:30:00	SPY	ETF	153.08	153.08	153.06	153.06	14800.0
2007-06-19 19:00:00	SPY	ETF	153.05	153.07	153.05	153.07	600.0
2007-06-19 19:30:00	SPY	ETF	153.08	153.08	153.07	153.07	1800.0
2007-06-19 04:00:00	QQQ	ETF	47.76	47.76	47.76	47.76	100.0
2007-06-19 06:30:00	QQQ	ETF	47.7	47.7	47.7	47.7	5000.0
2007-06-19 07:00:00	QQQ	ETF	47.7	47.71	47.68	47.7	42300.0
2007-06-19 07:30:00	QQQ	ETF	47.68	47.68	47.64	47.68	126000.0
2007-06-19 08:00:00	QQQ	ETF	47.69	47.69	47.57	47.6	985653.0
2007-06-19 08:30:00	QQQ	ETF	47.6	47.64	47.56	47.58	807088.0
2007-06-19 09:00:00	QQQ	ETF	47.59	47.64	47.58	47.63	591564.0
2007-06-19 09:30:00	QQQ	ETF	47.63	47.7	47.55	47.61	15058935.0
2007-06-19 10:00:00	QQQ	ETF	47.6	47.64	47.51	47.58	11165315.0
2007-06-19 10:30:00	QQQ	ETF	47.58	47.6994	47.58	47.67	6812806.0
2007-06-19 11:00:00	QQQ	ETF	47.6686	47.68	47.61	47.635	3184826.0
2007-06-19 11:30:00	QQQ	ETF	47.63	47.68	47.59	47.67	3601928.0
2007-06-19 12:00:00	QQQ	ETF	47.67	47.86	47.67	47.78	11003586.0
2007-06-19 12:30:00	QQQ	ETF	47.78	47.85	47.77	47.83	2977939.0
2007-06-19 13:00:00	QQQ	ETF	47.83	47.86	47.73	47.74	6146304.0
2007-06-19 13:30:00	QQQ	ETF	47.7365	47.76	47.68	47.71	5561634.0
2007-06-19 14:00:00	QQQ	ETF	47.7005	47.72	47.64	47.67	4235689.0
2007-06-19 14:30:00	QQQ	ETF	47.67	47.69	47.63	47.68	5063672.0
2007-06-19 15:00:00	QQQ	ETF	47.671	47.8029	47.65	47.75	9019785.0
2007-06-19 15:30:00	QQQ	ETF	47.75	47.82	47.735	47.77	12536689.0
2007-06-19 16:00:00	QQQ	ETF	47.77	47.797	47.74	47.77	2887197.0
2007-06-19 16:30:00	QQQ	ETF	47.76	47.77	47.74	47.76	197864.0
2007-06-19 17:00:00	QQQ	ETF	47.76	47.77	47.74	47.76	37227.0

> showing 50 of 4,404 rows — these rows as CSV

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