PREVIEW / etf_30min / 2009-10-29

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-29.parquet
  size:    242 KB
  rows:    7,922

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-10-29 04:00:00	SPY	ETF	104.7	104.82	104.68	104.82	7900.0
2009-10-29 04:30:00	SPY	ETF	104.73	104.75	104.73	104.75	1000.0
2009-10-29 05:00:00	SPY	ETF	104.72	104.88	104.7	104.84	2700.0
2009-10-29 05:30:00	SPY	ETF	104.85	104.85	104.78	104.8	850.0
2009-10-29 06:00:00	SPY	ETF	104.78	104.79	104.7	104.7	2800.0
2009-10-29 06:30:00	SPY	ETF	104.78	104.8	104.67	104.79	14700.0
2009-10-29 07:00:00	SPY	ETF	104.87	104.9	104.76	104.81	131150.0
2009-10-29 07:30:00	SPY	ETF	104.81	104.84	104.6	104.65	329732.0
2009-10-29 08:00:00	SPY	ETF	104.66	104.84	104.47	104.76	1477133.0
2009-10-29 08:30:00	SPY	ETF	104.7	105.44	104.67	105.43	7214242.0
2009-10-29 09:00:00	SPY	ETF	105.43	105.46	105.17	105.19	2475224.0
2009-10-29 09:30:00	SPY	ETF	105.19	105.43	104.94	105.29	29594575.0
2009-10-29 10:00:00	SPY	ETF	105.29	105.87	105.2	105.58	19194483.0
2009-10-29 10:30:00	SPY	ETF	105.58	105.72	105.39	105.72	10292579.0
2009-10-29 11:00:00	SPY	ETF	105.71	105.9	105.66	105.805	9384348.0
2009-10-29 11:30:00	SPY	ETF	105.8	105.93	105.66	105.8	7796088.0
2009-10-29 12:00:00	SPY	ETF	105.8	106.2	105.745	106.13	8240276.0
2009-10-29 12:30:00	SPY	ETF	106.13	106.42	106.08	106.26	9419149.0
2009-10-29 13:00:00	SPY	ETF	106.26	106.38	106.18	106.27	6906144.0
2009-10-29 13:30:00	SPY	ETF	106.27	106.5	106.24	106.38	7570082.0
2009-10-29 14:00:00	SPY	ETF	106.38	106.43	106.26	106.37	9141440.0
2009-10-29 14:30:00	SPY	ETF	106.37	106.69	106.36	106.68	8828161.0
2009-10-29 15:00:00	SPY	ETF	106.68	106.86	106.62	106.66	19013687.0
2009-10-29 15:30:00	SPY	ETF	106.65	106.76	106.35	106.64	30849112.0
2009-10-29 16:00:00	SPY	ETF	106.64	106.76	104.4107	106.62	7969132.0
2009-10-29 16:30:00	SPY	ETF	106.62	106.65	105.5995	106.51	752370.0
2009-10-29 17:00:00	SPY	ETF	106.51	106.63	106.46	106.62	83686.0
2009-10-29 17:30:00	SPY	ETF	106.57	106.68	106.56	106.61	71876.0
2009-10-29 18:00:00	SPY	ETF	106.63	106.7	106.63	106.7	45890.0
2009-10-29 18:30:00	SPY	ETF	106.71	106.71	106.65	106.69	14982.0
2009-10-29 19:00:00	SPY	ETF	106.7	106.71	106.65	106.68	12645.0
2009-10-29 19:30:00	SPY	ETF	106.67	106.71	106.54	106.61	23770.0
2009-10-29 04:00:00	QQQ	ETF	41.51	41.51	41.51	41.51	100.0
2009-10-29 04:30:00	QQQ	ETF	41.52	41.52	41.52	41.52	300.0
2009-10-29 05:30:00	QQQ	ETF	41.48	41.48	41.48	41.48	200.0
2009-10-29 06:00:00	QQQ	ETF	41.51	41.51	41.46	41.46	800.0
2009-10-29 06:30:00	QQQ	ETF	41.48	41.48	41.48	41.48	800.0
2009-10-29 07:00:00	QQQ	ETF	41.52	41.53	41.47	41.5	57950.0
2009-10-29 07:30:00	QQQ	ETF	41.5	41.5	41.44	41.45	265650.0
2009-10-29 08:00:00	QQQ	ETF	41.46	41.5	41.4	41.46	502849.0
2009-10-29 08:30:00	QQQ	ETF	41.47	41.86	41.47	41.85	2842164.0
2009-10-29 09:00:00	QQQ	ETF	41.85	41.86	41.68	41.68	1244014.0
2009-10-29 09:30:00	QQQ	ETF	41.68	41.78	41.54	41.72	14014407.0
2009-10-29 10:00:00	QQQ	ETF	41.72	41.98	41.69	41.83	10726253.0
2009-10-29 10:30:00	QQQ	ETF	41.82	41.94	41.77	41.94	5889799.0
2009-10-29 11:00:00	QQQ	ETF	41.93	41.99	41.87	41.95	5129324.0
2009-10-29 11:30:00	QQQ	ETF	41.9415	42.0	41.87	41.92	5323339.0
2009-10-29 12:00:00	QQQ	ETF	41.91	41.99	41.88	41.94	3795139.0
2009-10-29 12:30:00	QQQ	ETF	41.95	42.08	41.93	41.99	3884392.0
2009-10-29 13:00:00	QQQ	ETF	41.99	42.01	41.93	41.9599	3383519.0

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

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