PREVIEW / etf_30min / 2009-06-15

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-15.parquet
  size:    224 KB
  rows:    7,440

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-06-15 05:00:00	SPY	ETF	93.78	93.78	93.78	93.78	2500.0
2009-06-15 05:30:00	SPY	ETF	93.68	93.85	93.68	93.85	11000.0
2009-06-15 06:00:00	SPY	ETF	93.84	94.02	93.84	93.89	8000.0
2009-06-15 06:30:00	SPY	ETF	93.99	94.0	93.87	93.87	21050.0
2009-06-15 07:00:00	SPY	ETF	93.84	93.96	93.73	93.77	301302.0
2009-06-15 07:30:00	SPY	ETF	93.81	93.94	93.8	93.83	890235.0
2009-06-15 08:00:00	SPY	ETF	93.84	94.5129	93.76	93.89	1745229.0
2009-06-15 08:30:00	SPY	ETF	93.92	94.02	93.66	93.96	1386993.0
2009-06-15 09:00:00	SPY	ETF	93.96	93.99	93.77	93.96	2768662.0
2009-06-15 09:30:00	SPY	ETF	93.96	94.02	93.2	93.59	33803536.0
2009-06-15 10:00:00	SPY	ETF	93.59	93.63	93.32	93.41	13607819.0
2009-06-15 10:30:00	SPY	ETF	93.4	93.41	92.72	92.92	25119483.0
2009-06-15 11:00:00	SPY	ETF	92.92	93.75	92.56	92.67	14297888.0
2009-06-15 11:30:00	SPY	ETF	92.67	92.93	92.66	92.76	10650631.0
2009-06-15 12:00:00	SPY	ETF	92.76	92.82	92.55	92.6195	8533292.0
2009-06-15 12:30:00	SPY	ETF	92.62	92.85	92.61	92.81	9390181.0
2009-06-15 13:00:00	SPY	ETF	92.8	92.84	92.53	92.57	10617740.0
2009-06-15 13:30:00	SPY	ETF	92.57	92.69	92.42	92.59	9760667.0
2009-06-15 14:00:00	SPY	ETF	92.58	92.79	92.53	92.74	7704658.0
2009-06-15 14:30:00	SPY	ETF	92.75	92.75	92.43	92.6	10743925.0
2009-06-15 15:00:00	SPY	ETF	92.6	92.83	92.45	92.74	14442138.0
2009-06-15 15:30:00	SPY	ETF	92.74	93.01	92.69	92.86	32150799.0
2009-06-15 16:00:00	SPY	ETF	92.86	92.96	92.69	92.85	10648901.0
2009-06-15 16:30:00	SPY	ETF	92.85	95.0835	92.78	92.8	3388662.0
2009-06-15 17:00:00	SPY	ETF	92.82	95.0835	92.74	92.8	1255188.0
2009-06-15 17:30:00	SPY	ETF	92.8	92.8	92.75	92.8	14638.0
2009-06-15 18:00:00	SPY	ETF	92.8	92.82	92.77	92.78	45482.0
2009-06-15 18:30:00	SPY	ETF	92.79	92.82	92.78	92.82	7014.0
2009-06-15 19:00:00	SPY	ETF	92.8	92.82	92.77	92.78	8839.0
2009-06-15 19:30:00	SPY	ETF	92.76	92.85	92.73	92.84	17142.0
2009-06-15 05:00:00	QQQ	ETF	36.17	36.17	36.17	36.17	5000.0
2009-06-15 05:30:00	QQQ	ETF	36.16	36.16	36.16	36.16	3000.0
2009-06-15 07:00:00	QQQ	ETF	36.22	36.28	36.2	36.24	122806.0
2009-06-15 07:30:00	QQQ	ETF	36.27	36.29	36.22	36.22	65000.0
2009-06-15 08:00:00	QQQ	ETF	36.23	36.35	36.2	36.31	460451.0
2009-06-15 08:30:00	QQQ	ETF	36.3	36.33	36.24	36.29	267131.0
2009-06-15 09:00:00	QQQ	ETF	36.29	36.31	36.23	36.3	261254.0
2009-06-15 09:30:00	QQQ	ETF	36.28	36.33	35.96	36.04	20906090.0
2009-06-15 10:00:00	QQQ	ETF	36.03	36.08	35.93	36.0199	6529919.0
2009-06-15 10:30:00	QQQ	ETF	36.01	36.02	35.63	35.71	16208381.0
2009-06-15 11:00:00	QQQ	ETF	35.71	35.74	35.58	35.66	7457383.0
2009-06-15 11:30:00	QQQ	ETF	35.65	35.74	35.64	35.681	4922901.0
2009-06-15 12:00:00	QQQ	ETF	35.68	35.73	35.64	35.67	2626571.0
2009-06-15 12:30:00	QQQ	ETF	35.6799	35.79	35.67	35.77	5102882.0
2009-06-15 13:00:00	QQQ	ETF	35.77	35.8	35.68	35.689	4281900.0
2009-06-15 13:30:00	QQQ	ETF	35.68	35.74	35.59	35.7	4529776.0
2009-06-15 14:00:00	QQQ	ETF	35.7	35.82	35.68	35.79	3300728.0
2009-06-15 14:30:00	QQQ	ETF	35.79	35.79	35.65	35.74	4229683.0
2009-06-15 15:00:00	QQQ	ETF	35.73	35.84	35.67	35.8	5982655.0
2009-06-15 15:30:00	QQQ	ETF	35.81	35.93	35.79	35.9	15891053.0

> showing 50 of 7,440 rows — these rows as CSV

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