PREVIEW / etf_30min / 2009-12-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-29.parquet
  size:    227 KB
  rows:    7,619

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-29 05:30:00	SPY	ETF	112.89	112.89	112.89	112.89	650.0
2009-12-29 06:00:00	SPY	ETF	112.92	112.92	112.92	112.92	3000.0
2009-12-29 06:30:00	SPY	ETF	112.98	113.16	112.98	113.15	6100.0
2009-12-29 07:00:00	SPY	ETF	113.12	113.12	113.06	113.08	68060.0
2009-12-29 07:30:00	SPY	ETF	113.08	113.12	113.06	113.1	129010.0
2009-12-29 08:00:00	SPY	ETF	113.09	113.11	112.98	113.08	431582.0
2009-12-29 08:30:00	SPY	ETF	113.06	113.08	112.99	113.02	400333.0
2009-12-29 09:00:00	SPY	ETF	113.03	113.12	112.99	113.01	635491.0
2009-12-29 09:30:00	SPY	ETF	113.01	113.03	112.8101	112.88	9123834.0
2009-12-29 10:00:00	SPY	ETF	112.89	112.99	112.76	112.97	7230443.0
2009-12-29 10:30:00	SPY	ETF	112.97	112.99	112.83	112.85	3988358.0
2009-12-29 11:00:00	SPY	ETF	112.85	112.87	112.64	112.65	5157640.0
2009-12-29 11:30:00	SPY	ETF	112.64	112.76	112.62	112.7183	3692198.0
2009-12-29 12:00:00	SPY	ETF	112.71	112.74	112.58	112.621	5087531.0
2009-12-29 12:30:00	SPY	ETF	112.62	112.775	112.6	112.665	3326170.0
2009-12-29 13:00:00	SPY	ETF	112.67	112.73	112.63	112.7025	1822476.0
2009-12-29 13:30:00	SPY	ETF	112.7	112.81	112.67	112.8	4657039.0
2009-12-29 14:00:00	SPY	ETF	112.79	112.8	112.74	112.751	4409935.0
2009-12-29 14:30:00	SPY	ETF	112.75	112.79	112.67	112.7	3818830.0
2009-12-29 15:00:00	SPY	ETF	112.72	112.87	112.7	112.85	6263942.0
2009-12-29 15:30:00	SPY	ETF	112.85	112.86	112.55	112.58	12415071.0
2009-12-29 16:00:00	SPY	ETF	112.61	112.99	112.46	112.57	4761421.0
2009-12-29 16:30:00	SPY	ETF	112.56	112.6	112.53	112.57	59513.0
2009-12-29 17:00:00	SPY	ETF	112.56	112.59	112.53	112.58	11900.0
2009-12-29 17:30:00	SPY	ETF	112.53	112.59	112.53	112.59	2900.0
2009-12-29 18:00:00	SPY	ETF	112.58	112.58	112.55	112.57	6259.0
2009-12-29 18:30:00	SPY	ETF	112.55	112.6	112.55	112.56	2445.0
2009-12-29 19:00:00	SPY	ETF	112.52	112.55	112.41	112.45	36231.0
2009-12-29 19:30:00	SPY	ETF	112.42	112.42	112.33	112.41	21360.0
2009-12-29 06:00:00	QQQ	ETF	46.22	46.22	46.22	46.22	5000.0
2009-12-29 06:30:00	QQQ	ETF	46.27	46.27	46.27	46.27	5300.0
2009-12-29 07:00:00	QQQ	ETF	46.27	46.27	46.26	46.26	10000.0
2009-12-29 07:30:00	QQQ	ETF	46.25	46.26	46.23	46.26	27399.0
2009-12-29 08:00:00	QQQ	ETF	46.25	46.25	46.22	46.24	32760.0
2009-12-29 08:30:00	QQQ	ETF	46.24	46.25	46.23	46.23	37513.0
2009-12-29 09:00:00	QQQ	ETF	46.23	46.27	46.22	46.23	373193.0
2009-12-29 09:30:00	QQQ	ETF	46.23	46.25	46.11	46.16	4390211.0
2009-12-29 10:00:00	QQQ	ETF	46.16	46.16	46.04	46.1598	3349608.0
2009-12-29 10:30:00	QQQ	ETF	46.1598	46.17	46.1	46.1199	1150786.0
2009-12-29 11:00:00	QQQ	ETF	46.1101	46.13	46.02	46.02	2426589.0
2009-12-29 11:30:00	QQQ	ETF	46.03	46.08	46.01	46.06	1090189.0
2009-12-29 12:00:00	QQQ	ETF	46.0599	46.08	45.99	46.015	1765077.0
2009-12-29 12:30:00	QQQ	ETF	46.015	46.11	46.01	46.0505	2891795.0
2009-12-29 13:00:00	QQQ	ETF	46.05	46.06	46.03	46.05	842901.0
2009-12-29 13:30:00	QQQ	ETF	46.0505	46.12	46.04	46.11	1070403.0
2009-12-29 14:00:00	QQQ	ETF	46.1	46.11	46.07	46.0802	1119826.0
2009-12-29 14:30:00	QQQ	ETF	46.08	46.11	46.04	46.06	2038858.0
2009-12-29 15:00:00	QQQ	ETF	46.06	46.14	46.06	46.14	2605822.0
2009-12-29 15:30:00	QQQ	ETF	46.14	46.14	46.01	46.03	3195167.0
2009-12-29 16:00:00	QQQ	ETF	46.02	46.08	46.01	46.04	2617314.0

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

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