PREVIEW / etf_30min / 2009-02-13

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-02-13.parquet
  size:    198 KB
  rows:    6,614

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
2009-02-13 04:00:00	SPY	ETF	84.09	84.09	84.09	84.09	200.0
2009-02-13 04:30:00	SPY	ETF	84.13	84.35	84.13	84.28	2031.0
2009-02-13 05:00:00	SPY	ETF	84.25	84.26	84.16	84.26	900.0
2009-02-13 05:30:00	SPY	ETF	84.08	84.08	84.03	84.03	10100.0
2009-02-13 06:00:00	SPY	ETF	83.95	84.09	83.89	84.09	6700.0
2009-02-13 06:30:00	SPY	ETF	84.08	84.08	83.72	83.9	112700.0
2009-02-13 07:00:00	SPY	ETF	83.92	84.38	83.9	84.31	249626.0
2009-02-13 07:30:00	SPY	ETF	84.3	84.3	84.12	84.18	173627.0
2009-02-13 08:00:00	SPY	ETF	84.17	84.33	83.75	83.87	916077.0
2009-02-13 08:30:00	SPY	ETF	83.84	84.15	83.4	83.41	1949407.0
2009-02-13 09:00:00	SPY	ETF	83.41	84.1	83.27	83.55	2806693.0
2009-02-13 09:30:00	SPY	ETF	83.55	83.81	83.06	83.54	31460185.0
2009-02-13 10:00:00	SPY	ETF	83.54	83.91	83.29	83.87	26186158.0
2009-02-13 10:30:00	SPY	ETF	83.87	84.24	83.84	83.98	19628643.0
2009-02-13 11:00:00	SPY	ETF	83.99	84.01	83.3113	83.44	15839491.0
2009-02-13 11:30:00	SPY	ETF	83.45	83.67	83.07	83.08	16768764.0
2009-02-13 12:00:00	SPY	ETF	83.08	83.36	82.97	83.33	16352864.0
2009-02-13 12:30:00	SPY	ETF	83.32	83.42	82.75	82.91	13342736.0
2009-02-13 13:00:00	SPY	ETF	82.9	83.35	82.82	83.33	11985987.0
2009-02-13 13:30:00	SPY	ETF	83.33	84.01	83.19	83.79	20538175.0
2009-02-13 14:00:00	SPY	ETF	83.79	83.98	83.43	83.59	21576679.0
2009-02-13 14:30:00	SPY	ETF	83.59	83.75	83.37	83.54	18793518.0
2009-02-13 15:00:00	SPY	ETF	83.54	83.67	82.98	83.37	22399841.0
2009-02-13 15:30:00	SPY	ETF	83.37	84.0	82.78	82.78	33973906.0
2009-02-13 16:00:00	SPY	ETF	82.75	82.9547	82.35	82.6	9300726.0
2009-02-13 16:30:00	SPY	ETF	82.58	82.74	82.4	82.51	1248583.0
2009-02-13 17:00:00	SPY	ETF	82.5	82.55	82.39	82.55	704621.0
2009-02-13 17:30:00	SPY	ETF	82.55	82.57	82.48	82.48	125673.0
2009-02-13 18:00:00	SPY	ETF	82.51	82.57	82.5	82.56	33689.0
2009-02-13 18:30:00	SPY	ETF	82.56	82.68	82.56	82.65	116690.0
2009-02-13 19:00:00	SPY	ETF	82.62	82.64	82.58	82.58	18176.0
2009-02-13 19:30:00	SPY	ETF	82.6	82.6	82.54	82.55	12327.0
2009-02-13 04:30:00	QQQ	ETF	30.83	30.87	30.83	30.87	775.0
2009-02-13 05:00:00	QQQ	ETF	30.85	30.85	30.85	30.85	137.0
2009-02-13 05:30:00	QQQ	ETF	30.86	30.86	30.86	30.86	500.0
2009-02-13 06:30:00	QQQ	ETF	30.79	30.79	30.74	30.74	18000.0
2009-02-13 07:00:00	QQQ	ETF	30.8	30.89	30.8	30.85	35300.0
2009-02-13 07:30:00	QQQ	ETF	30.82	30.84	30.74	30.78	79411.0
2009-02-13 08:00:00	QQQ	ETF	30.81	30.81	30.61	30.65	861501.0
2009-02-13 08:30:00	QQQ	ETF	30.64	30.67	30.49	30.49	504159.0
2009-02-13 09:00:00	QQQ	ETF	30.49	30.58	30.45	30.45	1215691.0
2009-02-13 09:30:00	QQQ	ETF	30.46	30.63	30.29	30.5111	19272121.0
2009-02-13 10:00:00	QQQ	ETF	30.51	30.63	30.37	30.61	11101572.0
2009-02-13 10:30:00	QQQ	ETF	30.6	30.78	30.59	30.72	10714243.0
2009-02-13 11:00:00	QQQ	ETF	30.7201	30.7299	30.46	30.56	9391678.0
2009-02-13 11:30:00	QQQ	ETF	30.55	30.65	30.43	30.43	7954273.0
2009-02-13 12:00:00	QQQ	ETF	30.43	30.55	30.42	30.54	5345306.0
2009-02-13 12:30:00	QQQ	ETF	30.54	30.56	30.3	30.3685	7366213.0
2009-02-13 13:00:00	QQQ	ETF	30.37	30.53	30.33	30.51	6926785.0
2009-02-13 13:30:00	QQQ	ETF	30.51	30.73	30.49	30.66	11803995.0

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

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