PREVIEW / etf_30min / 2012-02-01

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-01.parquet
  size:    298 KB
  rows:    10,039

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-01 04:00:00	SPY	ETF	131.75	132.05	131.75	132.05	11150.0
2012-02-01 04:30:00	SPY	ETF	132.09	132.25	131.95	132.25	72950.0
2012-02-01 05:00:00	SPY	ETF	132.3	132.3	132.04	132.07	1699.0
2012-02-01 05:30:00	SPY	ETF	132.13	132.21	132.11	132.21	9000.0
2012-02-01 06:00:00	SPY	ETF	132.21	132.23	132.19	132.23	17200.0
2012-02-01 06:30:00	SPY	ETF	132.12	132.23	132.09	132.13	37950.0
2012-02-01 07:00:00	SPY	ETF	132.09	132.16	132.0	132.16	180952.0
2012-02-01 07:30:00	SPY	ETF	132.18	132.45	132.16	132.21	225127.0
2012-02-01 08:00:00	SPY	ETF	132.2	132.32	131.21	132.13	940362.0
2012-02-01 08:30:00	SPY	ETF	132.12	132.16	131.99	132.1	433208.0
2012-02-01 09:00:00	SPY	ETF	132.11	132.3	131.21	132.28	1124266.0
2012-02-01 09:30:00	SPY	ETF	132.29	132.51	132.13	132.28	15331023.0
2012-02-01 10:00:00	SPY	ETF	132.28	132.79	132.14	132.68	16594095.0
2012-02-01 10:30:00	SPY	ETF	132.68	132.75	132.56	132.72	7979001.0
2012-02-01 11:00:00	SPY	ETF	132.72	132.79	132.54	132.6707	8399008.0
2012-02-01 11:30:00	SPY	ETF	132.68	132.84	132.61	132.7	9137311.0
2012-02-01 12:00:00	SPY	ETF	132.695	132.98	132.69	132.9175	7508816.0
2012-02-01 12:30:00	SPY	ETF	132.9128	133.0	132.83	132.8999	6136852.0
2012-02-01 13:00:00	SPY	ETF	132.8985	133.12	132.88	132.999	9405332.0
2012-02-01 13:30:00	SPY	ETF	133.0	133.14	132.8	132.845	10656251.0
2012-02-01 14:00:00	SPY	ETF	132.85	132.92	132.76	132.9	5332733.0
2012-02-01 14:30:00	SPY	ETF	132.91	132.92	132.71	132.83	9129662.0
2012-02-01 15:00:00	SPY	ETF	132.84	133.0	132.64	132.67	13468855.0
2012-02-01 15:30:00	SPY	ETF	132.671	132.74	132.33	132.45	24160003.0
2012-02-01 16:00:00	SPY	ETF	132.45	133.05	131.245	132.48	12666137.0
2012-02-01 16:30:00	SPY	ETF	132.48	132.56	132.46	132.52	1936347.0
2012-02-01 17:00:00	SPY	ETF	132.53	132.58	132.4	132.58	770441.0
2012-02-01 17:30:00	SPY	ETF	132.59	132.6	132.55	132.58	525280.0
2012-02-01 18:00:00	SPY	ETF	132.58	132.63	132.56	132.62	34904.0
2012-02-01 18:30:00	SPY	ETF	132.62	132.64	132.54	132.55	27615.0
2012-02-01 19:00:00	SPY	ETF	132.55	132.85	132.55	132.83	178129.0
2012-02-01 19:30:00	SPY	ETF	132.83	132.91	132.76	132.78	237259.0
2012-02-01 04:00:00	QQQ	ETF	60.74	60.74	60.74	60.74	800.0
2012-02-01 04:30:00	QQQ	ETF	60.77	60.82	60.77	60.82	1200.0
2012-02-01 05:00:00	QQQ	ETF	60.75	60.78	60.75	60.78	275.0
2012-02-01 05:30:00	QQQ	ETF	60.82	60.85	60.81	60.81	4683.0
2012-02-01 06:00:00	QQQ	ETF	60.83	60.85	60.83	60.85	7300.0
2012-02-01 06:30:00	QQQ	ETF	60.83	60.9	60.83	60.9	1700.0
2012-02-01 07:00:00	QQQ	ETF	60.84	60.89	60.78	60.88	261123.0
2012-02-01 07:30:00	QQQ	ETF	60.89	60.99	60.87	60.87	205000.0
2012-02-01 08:00:00	QQQ	ETF	60.85	60.86	60.79	60.81	691902.0
2012-02-01 08:30:00	QQQ	ETF	60.81	60.81	60.75	60.78	154266.0
2012-02-01 09:00:00	QQQ	ETF	60.78	60.87	60.53	60.85	895072.0
2012-02-01 09:30:00	QQQ	ETF	60.85	60.95	60.69	60.7799	5854856.0
2012-02-01 10:00:00	QQQ	ETF	60.77	60.91	60.66	60.83	5209307.0
2012-02-01 10:30:00	QQQ	ETF	60.83	60.97	60.76	60.9599	2163422.0
2012-02-01 11:00:00	QQQ	ETF	60.96	61.0	60.85	60.93	3073598.0
2012-02-01 11:30:00	QQQ	ETF	60.922	61.09	60.92	61.04	3239890.0
2012-02-01 12:00:00	QQQ	ETF	61.03	61.15	61.03	61.11	2202932.0
2012-02-01 12:30:00	QQQ	ETF	61.1152	61.15	61.07	61.11	1161197.0

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

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