PREVIEW / etf_30min / 2011-02-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-24.parquet
  size:    288 KB
  rows:    9,467

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
2011-02-24 04:00:00	SPY	ETF	130.25	130.25	129.9	129.97	22189.0
2011-02-24 04:30:00	SPY	ETF	130.13	130.29	130.11	130.2	3300.0
2011-02-24 05:00:00	SPY	ETF	130.26	130.41	130.26	130.37	900.0
2011-02-24 05:30:00	SPY	ETF	130.48	130.51	130.3	130.3	30500.0
2011-02-24 06:00:00	SPY	ETF	130.4	130.45	130.32	130.32	29000.0
2011-02-24 06:30:00	SPY	ETF	130.31	130.31	130.15	130.19	173362.0
2011-02-24 07:00:00	SPY	ETF	130.19	130.36	130.16	130.35	335060.0
2011-02-24 07:30:00	SPY	ETF	130.34	130.34	130.13	130.19	504648.0
2011-02-24 08:00:00	SPY	ETF	130.2	130.56	130.2	130.52	2804099.0
2011-02-24 08:30:00	SPY	ETF	130.55	130.76	130.3	130.69	2412022.0
2011-02-24 09:00:00	SPY	ETF	130.7	131.17	130.67	130.88	4892124.0
2011-02-24 09:30:00	SPY	ETF	130.88	131.27	130.71	131.19	21256141.0
2011-02-24 10:00:00	SPY	ETF	131.2	131.44	130.87	131.1762	16905591.0
2011-02-24 10:30:00	SPY	ETF	131.18	131.18	130.79	130.95	11595369.0
2011-02-24 11:00:00	SPY	ETF	130.95	131.11	130.66	131.045	12167569.0
2011-02-24 11:30:00	SPY	ETF	131.04	131.1	130.44	130.6	12092608.0
2011-02-24 12:00:00	SPY	ETF	130.59	130.71	130.25	130.32	20609376.0
2011-02-24 12:30:00	SPY	ETF	130.315	130.59	130.18	130.55	12303065.0
2011-02-24 13:00:00	SPY	ETF	130.56	130.65	130.17	130.28	12002067.0
2011-02-24 13:30:00	SPY	ETF	130.28	130.41	129.7	129.9	19029802.0
2011-02-24 14:00:00	SPY	ETF	129.9	130.75	129.88	130.59	22679488.0
2011-02-24 14:30:00	SPY	ETF	130.58	130.92	130.46	130.75	19975571.0
2011-02-24 15:00:00	SPY	ETF	130.75	131.19	130.57	131.1	15781054.0
2011-02-24 15:30:00	SPY	ETF	131.105	131.28	130.83	130.93	25565886.0
2011-02-24 16:00:00	SPY	ETF	130.94	131.0394	130.527	130.69	13056693.0
2011-02-24 16:30:00	SPY	ETF	130.69	130.8933	130.6	130.67	3641125.0
2011-02-24 17:00:00	SPY	ETF	130.66	130.75	130.66	130.71	866886.0
2011-02-24 17:30:00	SPY	ETF	130.72	130.87	130.71	130.75	66745.0
2011-02-24 18:00:00	SPY	ETF	130.75	130.94	130.75	130.83	175165.0
2011-02-24 18:30:00	SPY	ETF	130.84	131.04	130.8	131.04	98767.0
2011-02-24 19:00:00	SPY	ETF	131.02	131.11	130.99	131.09	35100.0
2011-02-24 19:30:00	SPY	ETF	131.09	131.09	131.05	131.06	45500.0
2011-02-24 04:00:00	QQQ	ETF	56.27	56.27	56.13	56.14	1381.0
2011-02-24 04:30:00	QQQ	ETF	56.21	56.21	56.21	56.21	100.0
2011-02-24 05:00:00	QQQ	ETF	56.33	56.33	56.33	56.33	100.0
2011-02-24 06:00:00	QQQ	ETF	56.26	56.26	56.2	56.2	300.0
2011-02-24 06:30:00	QQQ	ETF	56.28	56.28	56.22	56.25	2600.0
2011-02-24 07:00:00	QQQ	ETF	56.24	56.28	56.2	56.27	99509.0
2011-02-24 07:30:00	QQQ	ETF	56.28	56.28	56.2	56.24	97151.0
2011-02-24 08:00:00	QQQ	ETF	56.24	56.41	56.23	56.41	882828.0
2011-02-24 08:30:00	QQQ	ETF	56.4	56.6	56.32	56.57	2009269.0
2011-02-24 09:00:00	QQQ	ETF	56.57	56.81	56.57	56.7	2200542.0
2011-02-24 09:30:00	QQQ	ETF	56.7	56.8	56.55	56.76	7911710.0
2011-02-24 10:00:00	QQQ	ETF	56.77	56.98	56.63	56.89	5378115.0
2011-02-24 10:30:00	QQQ	ETF	56.9	56.9	56.59	56.63	12435909.0
2011-02-24 11:00:00	QQQ	ETF	56.6217	56.74	56.46	56.69	4434866.0
2011-02-24 11:30:00	QQQ	ETF	56.7	56.73	56.4	56.57	4153110.0
2011-02-24 12:00:00	QQQ	ETF	56.57	56.61	56.38	56.42	3060571.0
2011-02-24 12:30:00	QQQ	ETF	56.42	56.59	56.38	56.577	2597846.0
2011-02-24 13:00:00	QQQ	ETF	56.57	56.64	56.42	56.4625	3548785.0

> showing 50 of 9,467 rows — these rows as CSV

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