PREVIEW / etf_30min / 2009-12-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-09.parquet
  size:    232 KB
  rows:    7,668

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-09 04:30:00	SPY	ETF	109.63	109.74	109.63	109.7	2100.0
2009-12-09 05:00:00	SPY	ETF	109.66	109.87	109.66	109.83	2850.0
2009-12-09 05:30:00	SPY	ETF	109.93	110.01	109.93	110.01	200.0
2009-12-09 06:00:00	SPY	ETF	109.97	109.97	109.9	109.9	3600.0
2009-12-09 06:30:00	SPY	ETF	110.01	110.11	110.0	110.11	3000.0
2009-12-09 07:00:00	SPY	ETF	110.21	110.21	110.04	110.06	56453.0
2009-12-09 07:30:00	SPY	ETF	110.04	110.08	109.97	110.02	53377.0
2009-12-09 08:00:00	SPY	ETF	110.03	110.12	109.68	109.93	1571731.0
2009-12-09 08:30:00	SPY	ETF	109.92	109.97	109.81	109.88	705359.0
2009-12-09 09:00:00	SPY	ETF	109.87	109.87	109.09	109.58	4266723.0
2009-12-09 09:30:00	SPY	ETF	109.58	109.8953	109.02	109.4099	23469030.0
2009-12-09 10:00:00	SPY	ETF	109.41	109.6	109.25	109.4	10842712.0
2009-12-09 10:30:00	SPY	ETF	109.4	110.01	109.16	109.75	16027365.0
2009-12-09 11:00:00	SPY	ETF	109.75	109.89	109.69	109.7	7699313.0
2009-12-09 11:30:00	SPY	ETF	109.6919	109.85	109.52	109.68	5932047.0
2009-12-09 12:00:00	SPY	ETF	109.67	109.68	109.3	109.44	7696735.0
2009-12-09 12:30:00	SPY	ETF	109.44	109.55	109.33	109.5	5665156.0
2009-12-09 13:00:00	SPY	ETF	109.4925	109.5	109.2	109.335	7921444.0
2009-12-09 13:30:00	SPY	ETF	109.34	109.38	109.11	109.22	6237686.0
2009-12-09 14:00:00	SPY	ETF	109.22	109.6558	109.18	109.361	7087926.0
2009-12-09 14:30:00	SPY	ETF	109.36	109.73	109.36	109.63	5526184.0
2009-12-09 15:00:00	SPY	ETF	109.63	110.18	109.625	109.99	14638367.0
2009-12-09 15:30:00	SPY	ETF	109.98	110.09	109.87	110.01	12756225.0
2009-12-09 16:00:00	SPY	ETF	110.0	110.1459	109.0961	110.04	7354248.0
2009-12-09 16:30:00	SPY	ETF	110.03	110.12	109.98	110.11	2503728.0
2009-12-09 17:00:00	SPY	ETF	110.12	110.19	109.61	110.17	586790.0
2009-12-09 17:30:00	SPY	ETF	110.18	110.19	110.14	110.17	10855.0
2009-12-09 18:00:00	SPY	ETF	110.18	110.24	110.14	110.21	42746.0
2009-12-09 18:30:00	SPY	ETF	110.2	110.2	110.16	110.18	15300.0
2009-12-09 19:00:00	SPY	ETF	110.22	110.34	110.16	110.32	14500.0
2009-12-09 19:30:00	SPY	ETF	110.35	110.39	110.26	110.35	29150.0
2009-12-09 04:30:00	QQQ	ETF	43.6	43.6	43.6	43.6	500.0
2009-12-09 05:00:00	QQQ	ETF	43.6	43.63	43.6	43.63	700.0
2009-12-09 05:30:00	QQQ	ETF	43.75	43.75	43.75	43.75	200.0
2009-12-09 06:00:00	QQQ	ETF	43.73	43.74	43.73	43.74	300.0
2009-12-09 06:30:00	QQQ	ETF	43.76	43.82	43.76	43.82	6400.0
2009-12-09 07:00:00	QQQ	ETF	43.85	43.86	43.8	43.82	15119.0
2009-12-09 07:30:00	QQQ	ETF	43.8	43.8	43.75	43.77	31887.0
2009-12-09 08:00:00	QQQ	ETF	43.78	43.82	43.73	43.73	254993.0
2009-12-09 08:30:00	QQQ	ETF	43.72	43.75	43.69	43.73	240237.0
2009-12-09 09:00:00	QQQ	ETF	43.7	43.7	43.55	43.61	696415.0
2009-12-09 09:30:00	QQQ	ETF	43.61	43.66	43.32	43.525	10707574.0
2009-12-09 10:00:00	QQQ	ETF	43.52	43.61	43.45	43.54	6035458.0
2009-12-09 10:30:00	QQQ	ETF	43.54	43.85	43.46	43.75	8646277.0
2009-12-09 11:00:00	QQQ	ETF	43.76	43.81	43.74	43.75	3684846.0
2009-12-09 11:30:00	QQQ	ETF	43.75	43.77	43.68	43.75	2053690.0
2009-12-09 12:00:00	QQQ	ETF	43.75	43.7501	43.6	43.6401	3649335.0
2009-12-09 12:30:00	QQQ	ETF	43.65	43.71	43.64	43.7	3481677.0
2009-12-09 13:00:00	QQQ	ETF	43.71	43.72	43.61	43.67	3812485.0
2009-12-09 13:30:00	QQQ	ETF	43.67	43.68	43.58	43.63	2386663.0

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

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