PREVIEW / etf_30min / 2011-07-25

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-25.parquet
  size:    284 KB
  rows:    9,536

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-07-25 04:00:00	SPY	ETF	133.74	133.74	133.38	133.41	10930.0
2011-07-25 04:30:00	SPY	ETF	133.62	133.7	133.62	133.7	200.0
2011-07-25 05:00:00	SPY	ETF	133.69	133.69	133.6	133.6	300.0
2011-07-25 05:30:00	SPY	ETF	133.59	133.63	133.55	133.61	1950.0
2011-07-25 06:00:00	SPY	ETF	133.67	133.67	133.28	133.41	7275.0
2011-07-25 06:30:00	SPY	ETF	133.48	133.56	133.38	133.51	39140.0
2011-07-25 07:00:00	SPY	ETF	133.51	133.68	133.49	133.67	525350.0
2011-07-25 07:30:00	SPY	ETF	133.68	133.68	133.52	133.56	575560.0
2011-07-25 08:00:00	SPY	ETF	133.56	134.5876	133.55	133.65	526852.0
2011-07-25 08:30:00	SPY	ETF	133.65	134.61	133.2	133.5	1483423.0
2011-07-25 09:00:00	SPY	ETF	133.51	134.59	133.28	133.29	1499750.0
2011-07-25 09:30:00	SPY	ETF	133.3	133.7	133.16	133.68	19195855.0
2011-07-25 10:00:00	SPY	ETF	133.68	134.13	133.65	133.95	15141383.0
2011-07-25 10:30:00	SPY	ETF	133.96	134.15	133.69	133.91	11518166.0
2011-07-25 11:00:00	SPY	ETF	133.915	134.22	133.81	134.14	8300607.0
2011-07-25 11:30:00	SPY	ETF	134.15	134.24	133.98	134.1	6188541.0
2011-07-25 12:00:00	SPY	ETF	134.11	134.23	134.06	134.2187	3569017.0
2011-07-25 12:30:00	SPY	ETF	134.2189	134.43	134.21	134.32	5936792.0
2011-07-25 13:00:00	SPY	ETF	134.32	134.49	134.3175	134.37	4698638.0
2011-07-25 13:30:00	SPY	ETF	134.37	134.41	134.21	134.2275	5763661.0
2011-07-25 14:00:00	SPY	ETF	134.23	134.44	134.2	134.4	3576333.0
2011-07-25 14:30:00	SPY	ETF	134.4	134.4	134.05	134.11	10579087.0
2011-07-25 15:00:00	SPY	ETF	134.11	134.13	133.82	133.93	10501315.0
2011-07-25 15:30:00	SPY	ETF	133.93	134.07	133.77	133.84	16772315.0
2011-07-25 16:00:00	SPY	ETF	133.85	134.17	133.78	133.82	8300379.0
2011-07-25 16:30:00	SPY	ETF	133.81	133.87	133.72	133.82	542214.0
2011-07-25 17:00:00	SPY	ETF	133.83	133.9	133.74	133.76	90449.0
2011-07-25 17:30:00	SPY	ETF	133.76	133.89	133.75	133.88	29037.0
2011-07-25 18:00:00	SPY	ETF	133.82	133.87	133.74	133.77	282118.0
2011-07-25 18:30:00	SPY	ETF	133.75	133.76	133.58	133.63	158424.0
2011-07-25 19:00:00	SPY	ETF	133.63	133.69	133.63	133.64	22333.0
2011-07-25 19:30:00	SPY	ETF	133.66	133.7	133.6	133.69	57466.0
2011-07-25 04:00:00	QQQ	ETF	59.32	59.32	59.3	59.3	400.0
2011-07-25 05:00:00	QQQ	ETF	59.38	59.38	59.36	59.36	1500.0
2011-07-25 05:30:00	QQQ	ETF	59.34	59.34	59.3	59.3	1800.0
2011-07-25 06:00:00	QQQ	ETF	59.28	59.28	59.28	59.28	100.0
2011-07-25 06:30:00	QQQ	ETF	59.23	59.29	59.23	59.29	2500.0
2011-07-25 07:00:00	QQQ	ETF	59.29	59.4	59.27	59.38	40383.0
2011-07-25 07:30:00	QQQ	ETF	59.35	59.35	59.28	59.29	35000.0
2011-07-25 08:00:00	QQQ	ETF	59.3	59.35	59.28	59.34	159158.0
2011-07-25 08:30:00	QQQ	ETF	59.33	59.33	59.24	59.25	91765.0
2011-07-25 09:00:00	QQQ	ETF	59.26	59.26	59.12	59.12	195129.0
2011-07-25 09:30:00	QQQ	ETF	59.13	59.38	59.02	59.36	8454375.0
2011-07-25 10:00:00	QQQ	ETF	59.35	59.51	59.305	59.47	8236298.0
2011-07-25 10:30:00	QQQ	ETF	59.48	59.57	59.34	59.4297	4115465.0
2011-07-25 11:00:00	QQQ	ETF	59.42	59.61	59.3801	59.59	2864322.0
2011-07-25 11:30:00	QQQ	ETF	59.6	59.66	59.5502	59.59	1711525.0
2011-07-25 12:00:00	QQQ	ETF	59.59	59.69	59.57	59.671	1569208.0
2011-07-25 12:30:00	QQQ	ETF	59.67	59.81	59.67	59.76	2646623.0
2011-07-25 13:00:00	QQQ	ETF	59.76	59.8	59.71	59.74	1752462.0

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

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