PREVIEW / etf_30min / 2009-12-21

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-21.parquet
  size:    236 KB
  rows:    7,973

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-12-21 04:30:00	SPY	ETF	110.34	110.34	110.34	110.34	100.0
2009-12-21 05:00:00	SPY	ETF	110.35	110.35	110.34	110.34	1300.0
2009-12-21 06:00:00	SPY	ETF	110.48	110.48	110.45	110.45	6000.0
2009-12-21 06:30:00	SPY	ETF	110.59	110.61	110.58	110.58	18200.0
2009-12-21 07:00:00	SPY	ETF	110.58	110.78	110.58	110.76	63898.0
2009-12-21 07:30:00	SPY	ETF	110.79	110.83	110.74	110.8	83508.0
2009-12-21 08:00:00	SPY	ETF	110.82	110.82	110.7	110.71	446858.0
2009-12-21 08:30:00	SPY	ETF	110.71	110.75	110.66	110.68	600667.0
2009-12-21 09:00:00	SPY	ETF	110.68	110.81	110.67	110.76	2051938.0
2009-12-21 09:30:00	SPY	ETF	110.76	111.35	110.76	111.18	20133875.0
2009-12-21 10:00:00	SPY	ETF	111.19	111.58	111.18	111.43	14039769.0
2009-12-21 10:30:00	SPY	ETF	111.43	111.52	111.29	111.35	7841700.0
2009-12-21 11:00:00	SPY	ETF	111.35	111.5	111.3	111.39	5027048.0
2009-12-21 11:30:00	SPY	ETF	111.39	111.54	111.35	111.49	6001379.0
2009-12-21 12:00:00	SPY	ETF	111.49	111.7	111.46	111.53	8755683.0
2009-12-21 12:30:00	SPY	ETF	111.54	111.58	111.39	111.49	5749546.0
2009-12-21 13:00:00	SPY	ETF	111.49	111.4999	111.31	111.42	5882411.0
2009-12-21 13:30:00	SPY	ETF	111.42	111.44	111.3	111.42	3602080.0
2009-12-21 14:00:00	SPY	ETF	111.405	111.53	111.34	111.4604	5484102.0
2009-12-21 14:30:00	SPY	ETF	111.46	111.47	111.38	111.4	2874172.0
2009-12-21 15:00:00	SPY	ETF	111.4	111.4	111.14	111.23	6757362.0
2009-12-21 15:30:00	SPY	ETF	111.23	111.36	111.21	111.34	11767809.0
2009-12-21 16:00:00	SPY	ETF	111.33	111.65	110.1563	111.18	7644728.0
2009-12-21 16:30:00	SPY	ETF	111.18	111.2	111.13	111.2	2473428.0
2009-12-21 17:00:00	SPY	ETF	111.2	111.22	111.18	111.18	31902.0
2009-12-21 17:30:00	SPY	ETF	111.18	111.2	111.15	111.19	12200.0
2009-12-21 18:00:00	SPY	ETF	111.19	111.35	111.18	111.32	98680.0
2009-12-21 18:30:00	SPY	ETF	111.33	111.35	111.29	111.34	39743.0
2009-12-21 19:00:00	SPY	ETF	111.32	111.35	111.32	111.35	7802.0
2009-12-21 19:30:00	SPY	ETF	111.33	111.36	111.3	111.32	18086.0
2009-12-21 06:00:00	QQQ	ETF	44.62	44.63	44.62	44.63	1300.0
2009-12-21 07:00:00	QQQ	ETF	44.63	44.71	44.63	44.71	29829.0
2009-12-21 07:30:00	QQQ	ETF	44.72	44.76	44.68	44.76	83043.0
2009-12-21 08:00:00	QQQ	ETF	44.76	44.77	44.68	44.7	387335.0
2009-12-21 08:30:00	QQQ	ETF	44.7	44.71	44.68	44.68	240759.0
2009-12-21 09:00:00	QQQ	ETF	44.68	44.7	44.62	44.67	922874.0
2009-12-21 09:30:00	QQQ	ETF	44.67	44.93	44.67	44.8983	11190161.0
2009-12-21 10:00:00	QQQ	ETF	44.9	45.06	44.87	44.97	10603355.0
2009-12-21 10:30:00	QQQ	ETF	44.97	45.01	44.9	44.97	3301532.0
2009-12-21 11:00:00	QQQ	ETF	44.97	45.06	44.8257	45.0074	4376770.0
2009-12-21 11:30:00	QQQ	ETF	45.01	45.05	44.99	45.0	1873311.0
2009-12-21 12:00:00	QQQ	ETF	45.015	45.13	44.9667	45.05	3630078.0
2009-12-21 12:30:00	QQQ	ETF	45.042	45.05	44.93	45.01	4490239.0
2009-12-21 13:00:00	QQQ	ETF	45.01	45.03	44.93	44.99	2816533.0
2009-12-21 13:30:00	QQQ	ETF	44.9874	45.02	44.91	45.01	5250951.0
2009-12-21 14:00:00	QQQ	ETF	45.0	45.07	44.97	45.04	4121352.0
2009-12-21 14:30:00	QQQ	ETF	45.04	45.04	45.0	45.024	1543085.0
2009-12-21 15:00:00	QQQ	ETF	45.02	45.03	44.88	44.9298	3945369.0
2009-12-21 15:30:00	QQQ	ETF	44.92	44.99	44.91	44.97	6592031.0
2009-12-21 16:00:00	QQQ	ETF	44.96	45.0	44.4351	44.95	6777371.0

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

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