PREVIEW / etf_30min / 2008-12-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-12-10.parquet
  size:    185 KB
  rows:    6,624

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-12-10 04:00:00	SPY	ETF	90.6	90.78	90.51	90.72	4110.0
2008-12-10 04:30:00	SPY	ETF	90.75	90.75	90.66	90.66	10100.0
2008-12-10 05:00:00	SPY	ETF	90.56	90.66	90.56	90.6	1400.0
2008-12-10 05:30:00	SPY	ETF	90.33	90.33	90.13	90.18	5700.0
2008-12-10 06:00:00	SPY	ETF	90.12	90.6	90.12	90.45	63600.0
2008-12-10 06:30:00	SPY	ETF	90.57	90.76	90.56	90.7	104788.0
2008-12-10 07:00:00	SPY	ETF	90.69	91.08	90.55	90.55	945316.0
2008-12-10 07:30:00	SPY	ETF	90.56	90.76	90.27	90.28	1031147.0
2008-12-10 08:00:00	SPY	ETF	90.29	90.82	90.08	90.3	3097560.0
2008-12-10 08:30:00	SPY	ETF	90.31	90.62	90.18	90.34	1484591.0
2008-12-10 09:00:00	SPY	ETF	90.34	90.53	90.24	90.3	1291030.0
2008-12-10 09:30:00	SPY	ETF	90.32	90.59	89.75	89.82	30477978.0
2008-12-10 10:00:00	SPY	ETF	89.82	90.98	89.75	90.66	23665096.0
2008-12-10 10:30:00	SPY	ETF	90.66	90.8	89.85	90.09	23425346.0
2008-12-10 11:00:00	SPY	ETF	90.09	90.82	89.94	90.62	18035335.0
2008-12-10 11:30:00	SPY	ETF	90.63	91.14	90.35	90.89	18048985.0
2008-12-10 12:00:00	SPY	ETF	90.89	91.36	90.33	90.36	20988905.0
2008-12-10 12:30:00	SPY	ETF	90.38	90.58	90.05	90.1592	18860804.0
2008-12-10 13:00:00	SPY	ETF	90.15	90.86	90.03	90.46	22722757.0
2008-12-10 13:30:00	SPY	ETF	90.47	90.53	89.2	89.4	26501010.0
2008-12-10 14:00:00	SPY	ETF	89.399	89.73	89.0	89.37	28526595.0
2008-12-10 14:30:00	SPY	ETF	89.38	89.94	89.05	89.705	37997904.0
2008-12-10 15:00:00	SPY	ETF	89.7	90.4	89.47	90.36	32207163.0
2008-12-10 15:30:00	SPY	ETF	90.36	90.7	89.61	90.35	39744450.0
2008-12-10 16:00:00	SPY	ETF	90.32	90.4	89.8289	90.1	16926842.0
2008-12-10 16:30:00	SPY	ETF	90.1	90.41	89.3523	90.05	13344284.0
2008-12-10 17:00:00	SPY	ETF	90.03	90.05	89.98	90.03	74561.0
2008-12-10 17:30:00	SPY	ETF	90.01	90.08	89.3524	89.98	1021998.0
2008-12-10 18:00:00	SPY	ETF	89.99	90.1	89.9	89.9	77059.0
2008-12-10 18:30:00	SPY	ETF	89.94	89.95	89.81	89.87	29864.0
2008-12-10 19:00:00	SPY	ETF	89.81	89.84	89.63	89.68	53090.0
2008-12-10 19:30:00	SPY	ETF	89.68	90.0	89.6	89.98	77633.0
2008-12-10 04:00:00	QQQ	ETF	30.4	30.4	30.4	30.4	130.0
2008-12-10 04:30:00	QQQ	ETF	30.39	30.43	30.39	30.39	1500.0
2008-12-10 06:30:00	QQQ	ETF	30.42	30.42	30.38	30.38	300.0
2008-12-10 07:00:00	QQQ	ETF	30.45	30.45	30.37	30.4	54307.0
2008-12-10 07:30:00	QQQ	ETF	30.33	30.36	30.22	30.22	142953.0
2008-12-10 08:00:00	QQQ	ETF	30.22	30.25	30.16	30.2	639735.0
2008-12-10 08:30:00	QQQ	ETF	30.21	30.29	30.18	30.2	523817.0
2008-12-10 09:00:00	QQQ	ETF	30.2	30.25	30.03	30.1	787830.0
2008-12-10 09:30:00	QQQ	ETF	30.09	30.19	29.75	29.94	16823907.0
2008-12-10 10:00:00	QQQ	ETF	29.95	30.27	29.93	30.17	10407595.0
2008-12-10 10:30:00	QQQ	ETF	30.17	30.26	29.92	30.01	9104783.0
2008-12-10 11:00:00	QQQ	ETF	30.01	30.3	29.96	30.21	8852586.0
2008-12-10 11:30:00	QQQ	ETF	30.21	30.381	30.12	30.28	6758222.0
2008-12-10 12:00:00	QQQ	ETF	30.28	30.46	30.15	30.19	10281196.0
2008-12-10 12:30:00	QQQ	ETF	30.18	30.22	30.05	30.09	5853839.0
2008-12-10 13:00:00	QQQ	ETF	30.08	30.29	30.05	30.1311	5120895.0
2008-12-10 13:30:00	QQQ	ETF	30.13	30.16	29.76	29.8	8405089.0
2008-12-10 14:00:00	QQQ	ETF	29.8	29.881	29.62	29.71	9600309.0

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

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