PREVIEW / etf_30min / 2010-03-02

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-03-02.parquet
  size:    247 KB
  rows:    8,414

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
2010-03-02 04:00:00	SPY	ETF	111.81	111.82	111.81	111.82	200.0
2010-03-02 04:30:00	SPY	ETF	111.92	111.93	111.9	111.93	5600.0
2010-03-02 05:30:00	SPY	ETF	111.98	111.98	111.98	111.98	3800.0
2010-03-02 06:00:00	SPY	ETF	112.18	112.3	112.18	112.3	34800.0
2010-03-02 06:30:00	SPY	ETF	112.28	112.68	112.27	112.41	103645.0
2010-03-02 07:00:00	SPY	ETF	112.45	112.55	112.4	112.47	251351.0
2010-03-02 07:30:00	SPY	ETF	112.44	112.58	112.39	112.53	432828.0
2010-03-02 08:00:00	SPY	ETF	112.53	112.65	112.38	112.58	977900.0
2010-03-02 08:30:00	SPY	ETF	112.58	112.63	112.48	112.5	644567.0
2010-03-02 09:00:00	SPY	ETF	112.5	112.54	112.31	112.37	925689.0
2010-03-02 09:30:00	SPY	ETF	112.37	112.53	112.21	112.38	19286223.0
2010-03-02 10:00:00	SPY	ETF	112.38	112.52	112.1	112.281	13545429.0
2010-03-02 10:30:00	SPY	ETF	112.28	112.57	112.25	112.46	11632495.0
2010-03-02 11:00:00	SPY	ETF	112.46	112.65	112.45	112.61	9219683.0
2010-03-02 11:30:00	SPY	ETF	112.61	112.66	112.51	112.58	9373742.0
2010-03-02 12:00:00	SPY	ETF	112.58	112.64	112.4	112.455	6154742.0
2010-03-02 12:30:00	SPY	ETF	112.4501	112.51	112.35	112.48	4757886.0
2010-03-02 13:00:00	SPY	ETF	112.48	112.56	112.41	112.52	3027633.0
2010-03-02 13:30:00	SPY	ETF	112.52	112.74	112.49	112.67	7305433.0
2010-03-02 14:00:00	SPY	ETF	112.67	112.74	112.4	112.4	12153492.0
2010-03-02 14:30:00	SPY	ETF	112.4	112.55	112.19	112.23	12507665.0
2010-03-02 15:00:00	SPY	ETF	112.23	112.715	112.09	112.09	14358929.0
2010-03-02 15:30:00	SPY	ETF	112.09	112.23	112.0	112.17	22536521.0
2010-03-02 16:00:00	SPY	ETF	112.16	112.51	112.16	112.23	5748247.0
2010-03-02 16:30:00	SPY	ETF	112.22	112.42	112.2	112.3	5312627.0
2010-03-02 17:00:00	SPY	ETF	112.31	112.34	112.28	112.29	195243.0
2010-03-02 17:30:00	SPY	ETF	112.27	112.27	112.23	112.24	53606.0
2010-03-02 18:00:00	SPY	ETF	112.25	112.31	112.19	112.24	19363.0
2010-03-02 18:30:00	SPY	ETF	112.27	112.27	112.23	112.25	15015.0
2010-03-02 19:00:00	SPY	ETF	112.24	112.29	112.24	112.26	24681.0
2010-03-02 19:30:00	SPY	ETF	112.28	112.3	112.24	112.24	12618.0
2010-03-02 04:00:00	QQQ	ETF	45.43	45.43	45.43	45.43	193.0
2010-03-02 04:30:00	QQQ	ETF	45.4	45.4	45.39	45.39	2600.0
2010-03-02 05:30:00	QQQ	ETF	45.47	45.49	45.47	45.49	8000.0
2010-03-02 06:00:00	QQQ	ETF	45.5	45.51	45.5	45.51	4840.0
2010-03-02 06:30:00	QQQ	ETF	45.53	45.63	45.53	45.54	51704.0
2010-03-02 07:00:00	QQQ	ETF	45.57	45.62	45.56	45.58	52139.0
2010-03-02 07:30:00	QQQ	ETF	45.57	45.61	45.55	45.6	76179.0
2010-03-02 08:00:00	QQQ	ETF	45.59	45.63	45.56	45.6	191938.0
2010-03-02 08:30:00	QQQ	ETF	45.6	45.63	45.58	45.61	537059.0
2010-03-02 09:00:00	QQQ	ETF	45.61	45.62	45.53	45.54	1167604.0
2010-03-02 09:30:00	QQQ	ETF	45.54	45.71	45.54	45.66	15526954.0
2010-03-02 10:00:00	QQQ	ETF	45.66	45.71	45.53	45.63	7214960.0
2010-03-02 10:30:00	QQQ	ETF	45.63	45.7	45.63	45.64	4307618.0
2010-03-02 11:00:00	QQQ	ETF	45.64	45.72	45.63	45.7	3147981.0
2010-03-02 11:30:00	QQQ	ETF	45.7	45.76	45.65	45.73	3432417.0
2010-03-02 12:00:00	QQQ	ETF	45.73	45.7475	45.62	45.66	3315677.0
2010-03-02 12:30:00	QQQ	ETF	45.66	45.7	45.61	45.69	2702557.0
2010-03-02 13:00:00	QQQ	ETF	45.69	45.72	45.67	45.6901	1570006.0
2010-03-02 13:30:00	QQQ	ETF	45.69	45.83	45.69	45.82	2824168.0

> showing 50 of 8,414 rows — these rows as CSV

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