PREVIEW / etf_30min / 2012-02-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-03.parquet
  size:    303 KB
  rows:    10,200

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
2012-02-03 04:00:00	SPY	ETF	132.69	132.8	132.69	132.72	7508.0
2012-02-03 04:30:00	SPY	ETF	132.88	132.93	132.88	132.93	500.0
2012-02-03 05:00:00	SPY	ETF	132.96	133.0	132.96	132.98	5655.0
2012-02-03 05:30:00	SPY	ETF	133.04	133.04	133.04	133.04	100.0
2012-02-03 06:00:00	SPY	ETF	132.95	133.02	132.9	132.97	23367.0
2012-02-03 06:30:00	SPY	ETF	132.98	132.99	132.85	132.96	23100.0
2012-02-03 07:00:00	SPY	ETF	132.92	133.04	132.9	132.92	76824.0
2012-02-03 07:30:00	SPY	ETF	132.93	132.98	132.72	132.77	98665.0
2012-02-03 08:00:00	SPY	ETF	132.78	132.91	132.68	132.78	691322.0
2012-02-03 08:30:00	SPY	ETF	132.84	134.12	132.84	133.94	7988682.0
2012-02-03 09:00:00	SPY	ETF	133.94	134.06	133.84	134.0	2566886.0
2012-02-03 09:30:00	SPY	ETF	134.0	134.05	133.77	134.021	15185535.0
2012-02-03 10:00:00	SPY	ETF	134.025	134.39	134.02	134.21	17642670.0
2012-02-03 10:30:00	SPY	ETF	134.21	134.41	134.2	134.26	7870673.0
2012-02-03 11:00:00	SPY	ETF	134.25	134.41	134.14	134.37	8420408.0
2012-02-03 11:30:00	SPY	ETF	134.38	134.42	134.26	134.265	6308504.0
2012-02-03 12:00:00	SPY	ETF	134.265	134.42	134.21	134.42	5170486.0
2012-02-03 12:30:00	SPY	ETF	134.4192	134.56	134.33	134.45	10987915.0
2012-02-03 13:00:00	SPY	ETF	134.45	134.48	134.4	134.42	4899937.0
2012-02-03 13:30:00	SPY	ETF	134.41	134.42	134.31	134.35	3904170.0
2012-02-03 14:00:00	SPY	ETF	134.35	134.51	134.35	134.47	7639359.0
2012-02-03 14:30:00	SPY	ETF	134.47	134.51	134.4	134.5	6416325.0
2012-02-03 15:00:00	SPY	ETF	134.5	134.51	134.32	134.4	6868067.0
2012-02-03 15:30:00	SPY	ETF	134.4	134.62	134.29	134.55	24059691.0
2012-02-03 16:00:00	SPY	ETF	134.56	134.6	134.32	134.4	11373816.0
2012-02-03 16:30:00	SPY	ETF	134.39	134.54	134.365	134.54	584084.0
2012-02-03 17:00:00	SPY	ETF	134.51	134.57	134.44	134.52	1272628.0
2012-02-03 17:30:00	SPY	ETF	134.5	134.5	134.34	134.38	102771.0
2012-02-03 18:00:00	SPY	ETF	134.37	134.46	134.37	134.42	43833.0
2012-02-03 18:30:00	SPY	ETF	134.42	134.48	134.4	134.48	11835.0
2012-02-03 19:00:00	SPY	ETF	134.47	134.51	134.47	134.51	15793.0
2012-02-03 19:30:00	SPY	ETF	134.52	134.52	134.46	134.49	9824.0
2012-02-03 04:30:00	QQQ	ETF	61.34	61.34	61.34	61.34	200.0
2012-02-03 06:30:00	QQQ	ETF	61.34	61.37	61.33	61.33	6000.0
2012-02-03 07:00:00	QQQ	ETF	61.39	61.43	61.39	61.4	4350.0
2012-02-03 07:30:00	QQQ	ETF	61.38	61.4	61.34	61.34	1300.0
2012-02-03 08:00:00	QQQ	ETF	61.34	61.38	61.2	61.32	75777.0
2012-02-03 08:30:00	QQQ	ETF	61.39	61.86	61.39	61.76	1317911.0
2012-02-03 09:00:00	QQQ	ETF	61.76	61.85	61.71	61.77	459121.0
2012-02-03 09:30:00	QQQ	ETF	61.77	61.9	61.6799	61.87	5972403.0
2012-02-03 10:00:00	QQQ	ETF	61.88	62.02	61.819	61.92	4756354.0
2012-02-03 10:30:00	QQQ	ETF	61.929	62.02	61.92	61.98	2289892.0
2012-02-03 11:00:00	QQQ	ETF	61.98	62.01	61.91	61.981	2469752.0
2012-02-03 11:30:00	QQQ	ETF	61.99	62.05	61.95	61.96	1563040.0
2012-02-03 12:00:00	QQQ	ETF	61.95	62.06	61.93	62.0595	1385911.0
2012-02-03 12:30:00	QQQ	ETF	62.05	62.12	62.03	62.0718	2319705.0
2012-02-03 13:00:00	QQQ	ETF	62.08	62.1	62.05	62.07	828951.0
2012-02-03 13:30:00	QQQ	ETF	62.08	62.08	62.0	62.0	910264.0
2012-02-03 14:00:00	QQQ	ETF	62.005	62.08	62.0	62.06	1658036.0
2012-02-03 14:30:00	QQQ	ETF	62.055	62.07	62.03	62.06	1051535.0

> showing 50 of 10,200 rows — these rows as CSV

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