PREVIEW / etf_30min / 2009-06-11

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-11.parquet
  size:    223 KB
  rows:    7,346

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-11 04:30:00	SPY	ETF	94.74	94.8	94.74	94.8	4267.0
2009-06-11 05:00:00	SPY	ETF	94.86	94.86	94.84	94.84	2600.0
2009-06-11 05:30:00	SPY	ETF	94.79	94.8	94.79	94.8	15000.0
2009-06-11 06:00:00	SPY	ETF	94.83	94.83	94.75	94.79	31000.0
2009-06-11 06:30:00	SPY	ETF	94.8	94.8	94.76	94.76	4100.0
2009-06-11 07:00:00	SPY	ETF	94.75	94.75	94.65	94.67	138956.0
2009-06-11 07:30:00	SPY	ETF	94.69	94.72	94.61	94.63	492275.0
2009-06-11 08:00:00	SPY	ETF	94.63	94.74	94.45	94.71	3436881.0
2009-06-11 08:30:00	SPY	ETF	94.71	95.05	94.15	94.19	4577361.0
2009-06-11 09:00:00	SPY	ETF	94.19	94.6	94.18	94.58	2706300.0
2009-06-11 09:30:00	SPY	ETF	94.58	95.35	94.56	95.18	28716146.0
2009-06-11 10:00:00	SPY	ETF	95.18	95.53	95.04	95.19	21018373.0
2009-06-11 10:30:00	SPY	ETF	95.19	95.29	95.03	95.05	9968844.0
2009-06-11 11:00:00	SPY	ETF	95.05	95.39	94.93	95.38	11652190.0
2009-06-11 11:30:00	SPY	ETF	95.38	95.39	95.12	95.24	9814992.0
2009-06-11 12:00:00	SPY	ETF	95.24	95.29	95.0	95.18	11903692.0
2009-06-11 12:30:00	SPY	ETF	95.18	95.69	95.155	95.65	15411413.0
2009-06-11 13:00:00	SPY	ETF	95.65	96.09	95.53	96.09	27510761.0
2009-06-11 13:30:00	SPY	ETF	96.08	96.11	95.67	95.74	16358084.0
2009-06-11 14:00:00	SPY	ETF	95.74	95.83	94.95	95.81	17235758.0
2009-06-11 14:30:00	SPY	ETF	95.81	95.88	95.43	95.75	17603090.0
2009-06-11 15:00:00	SPY	ETF	95.74	95.85	95.47	95.49	11250107.0
2009-06-11 15:30:00	SPY	ETF	95.49	95.8869	94.81	94.88	36559869.0
2009-06-11 16:00:00	SPY	ETF	94.88	95.8869	94.61	94.62	18901424.0
2009-06-11 16:30:00	SPY	ETF	94.62	94.65	94.3761	94.62	5831041.0
2009-06-11 17:00:00	SPY	ETF	94.64	94.68	94.6	94.62	95707.0
2009-06-11 17:30:00	SPY	ETF	94.67	94.67	94.62	94.62	1026400.0
2009-06-11 18:00:00	SPY	ETF	94.62	94.85	94.57	94.6	54983.0
2009-06-11 18:30:00	SPY	ETF	94.6	94.62	94.57	94.6	52180.0
2009-06-11 19:00:00	SPY	ETF	94.6	94.69	94.58	94.67	37854.0
2009-06-11 19:30:00	SPY	ETF	94.68	94.7	94.59	94.7	12756.0
2009-06-11 05:30:00	QQQ	ETF	36.98	36.98	36.98	36.98	700.0
2009-06-11 06:00:00	QQQ	ETF	36.98	36.98	36.98	36.98	200.0
2009-06-11 07:00:00	QQQ	ETF	36.94	36.94	36.89	36.93	190279.0
2009-06-11 07:30:00	QQQ	ETF	36.94	36.95	36.9	36.9	164088.0
2009-06-11 08:00:00	QQQ	ETF	36.89	36.9	36.72	36.81	4392251.0
2009-06-11 08:30:00	QQQ	ETF	36.81	36.87	36.63	36.65	1668776.0
2009-06-11 09:00:00	QQQ	ETF	36.65	36.87	36.64	36.76	3633834.0
2009-06-11 09:30:00	QQQ	ETF	36.76	37.15	36.75	37.07	19669780.0
2009-06-11 10:00:00	QQQ	ETF	37.08	37.2	37.0	37.076	10469263.0
2009-06-11 10:30:00	QQQ	ETF	37.08	37.11	36.96	36.96	5428602.0
2009-06-11 11:00:00	QQQ	ETF	36.96	37.079	36.89	37.06	6367728.0
2009-06-11 11:30:00	QQQ	ETF	37.06	37.06	36.91	36.95	5316316.0
2009-06-11 12:00:00	QQQ	ETF	36.95	36.95	36.77	36.85	8658238.0
2009-06-11 12:30:00	QQQ	ETF	36.85	37.0701	36.8426	37.05	9144734.0
2009-06-11 13:00:00	QQQ	ETF	37.06	37.23	37.01	37.22	10577899.0
2009-06-11 13:30:00	QQQ	ETF	37.23	37.23	37.1	37.12	5491592.0
2009-06-11 14:00:00	QQQ	ETF	37.128	37.17	37.02	37.1499	9574095.0
2009-06-11 14:30:00	QQQ	ETF	37.145	37.17	37.02	37.13	7595385.0
2009-06-11 15:00:00	QQQ	ETF	37.13	37.18	37.0	37.01	4782744.0

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

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