PREVIEW / etf_30min / 2009-12-31

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-31.parquet
  size:    231 KB
  rows:    7,803

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-31 04:00:00	SPY	ETF	112.6	112.6	112.6	112.6	100.0
2009-12-31 05:00:00	SPY	ETF	112.74	112.74	112.74	112.74	100.0
2009-12-31 06:30:00	SPY	ETF	112.84	112.84	112.84	112.84	200.0
2009-12-31 07:00:00	SPY	ETF	112.84	112.9	112.84	112.87	4760.0
2009-12-31 07:30:00	SPY	ETF	112.82	112.87	112.8	112.84	63628.0
2009-12-31 08:00:00	SPY	ETF	112.84	112.86	112.71	112.76	787841.0
2009-12-31 08:30:00	SPY	ETF	112.77	112.92	112.73	112.86	993447.0
2009-12-31 09:00:00	SPY	ETF	112.85	112.86	112.76	112.77	525279.0
2009-12-31 09:30:00	SPY	ETF	112.77	112.8	112.61	112.62	6261682.0
2009-12-31 10:00:00	SPY	ETF	112.6174	112.62	112.41	112.46	4939167.0
2009-12-31 10:30:00	SPY	ETF	112.45	112.46	112.33	112.4	4462306.0
2009-12-31 11:00:00	SPY	ETF	112.4	112.41	112.15	112.23	5776508.0
2009-12-31 11:30:00	SPY	ETF	112.23	112.34	112.16	112.23	4866364.0
2009-12-31 12:00:00	SPY	ETF	112.22	112.3	112.22	112.26	2448938.0
2009-12-31 12:30:00	SPY	ETF	112.26	112.33	112.22	112.28	4989555.0
2009-12-31 13:00:00	SPY	ETF	112.28	112.6386	112.15	112.25	3947652.0
2009-12-31 13:30:00	SPY	ETF	112.24	112.33	112.23	112.27	5395186.0
2009-12-31 14:00:00	SPY	ETF	112.26	112.6386	112.2	112.21	5265856.0
2009-12-31 14:30:00	SPY	ETF	112.21	112.31	112.2	112.3	1982511.0
2009-12-31 15:00:00	SPY	ETF	112.3	112.35	112.21	112.27	4620934.0
2009-12-31 15:30:00	SPY	ETF	112.28	112.3	111.43	111.44	21710022.0
2009-12-31 16:00:00	SPY	ETF	111.44	112.6386	111.42	111.56	9694932.0
2009-12-31 16:30:00	SPY	ETF	111.57	111.62	111.44	111.48	538482.0
2009-12-31 17:00:00	SPY	ETF	111.5	111.59	111.5	111.58	44719.0
2009-12-31 17:30:00	SPY	ETF	111.58	111.59	111.4	111.41	68576.0
2009-12-31 18:00:00	SPY	ETF	111.44	111.46	111.23	111.23	66676.0
2009-12-31 18:30:00	SPY	ETF	111.29	111.29	111.01	111.02	170849.0
2009-12-31 19:00:00	SPY	ETF	111.02	111.2	111.0	111.0	147645.0
2009-12-31 19:30:00	SPY	ETF	111.0	111.13	110.92	111.0	98767.0
2009-12-31 07:00:00	QQQ	ETF	46.24	46.24	46.24	46.24	500.0
2009-12-31 07:30:00	QQQ	ETF	46.22	46.24	46.22	46.23	5100.0
2009-12-31 08:00:00	QQQ	ETF	46.23	46.24	46.21	46.22	235565.0
2009-12-31 08:30:00	QQQ	ETF	46.23	46.29	46.21	46.28	371095.0
2009-12-31 09:00:00	QQQ	ETF	46.27	46.27	46.24	46.25	239288.0
2009-12-31 09:30:00	QQQ	ETF	46.25	46.275	46.15	46.175	5856686.0
2009-12-31 10:00:00	QQQ	ETF	46.1737	46.19	46.04	46.05	4720847.0
2009-12-31 10:30:00	QQQ	ETF	46.06	46.1	46.03	46.08	2297786.0
2009-12-31 11:00:00	QQQ	ETF	46.08	46.09	45.965	45.99	2363027.0
2009-12-31 11:30:00	QQQ	ETF	45.99	46.075	45.97	46.02	2162656.0
2009-12-31 12:00:00	QQQ	ETF	46.02	46.06	46.02	46.03	635531.0
2009-12-31 12:30:00	QQQ	ETF	46.03	46.05	46.02	46.03	913335.0
2009-12-31 13:00:00	QQQ	ETF	46.038	46.04	45.95	46.0	1104159.0
2009-12-31 13:30:00	QQQ	ETF	46.008	46.03	46.0	46.009	915274.0
2009-12-31 14:00:00	QQQ	ETF	46.0074	46.01	45.96	45.96	919198.0
2009-12-31 14:30:00	QQQ	ETF	45.9676	46.01	45.96	45.995	1388390.0
2009-12-31 15:00:00	QQQ	ETF	45.9999	46.0431	45.97	45.99	2740795.0
2009-12-31 15:30:00	QQQ	ETF	45.98	46.0	45.75	45.76	11838161.0
2009-12-31 16:00:00	QQQ	ETF	45.75	46.0431	45.74	45.93	10684996.0
2009-12-31 16:30:00	QQQ	ETF	45.9921	45.9921	45.84	45.86	113700.0
2009-12-31 17:00:00	QQQ	ETF	45.86	45.9	45.84	45.85	15615.0

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

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