PREVIEW / etf_30min / 2012-06-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-27.parquet
  size:    272 KB
  rows:    9,092

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-06-27 04:00:00	SPY	ETF	132.07	132.09	132.07	132.09	1000.0
2012-06-27 05:00:00	SPY	ETF	132.11	132.11	132.11	132.11	500.0
2012-06-27 05:30:00	SPY	ETF	132.14	132.15	132.03	132.1	2600.0
2012-06-27 06:00:00	SPY	ETF	132.24	132.25	132.14	132.14	2675.0
2012-06-27 06:30:00	SPY	ETF	132.11	132.35	132.11	132.23	62848.0
2012-06-27 07:00:00	SPY	ETF	132.28	132.43	132.26	132.26	77550.0
2012-06-27 07:30:00	SPY	ETF	132.3	132.41	132.28	132.41	71189.0
2012-06-27 08:00:00	SPY	ETF	132.39	132.51	132.23	132.27	255550.0
2012-06-27 08:30:00	SPY	ETF	132.28	132.44	132.12	132.19	873292.0
2012-06-27 09:00:00	SPY	ETF	132.18	132.43	132.09	132.42	1750173.0
2012-06-27 09:30:00	SPY	ETF	132.42	132.74	132.31	132.63	13413902.0
2012-06-27 10:00:00	SPY	ETF	132.62	133.18	132.5	133.085	12710803.0
2012-06-27 10:30:00	SPY	ETF	133.08	133.15	132.83	133.0	7874226.0
2012-06-27 11:00:00	SPY	ETF	132.995	133.08	132.71	132.85	7231083.0
2012-06-27 11:30:00	SPY	ETF	132.85	133.22	132.85	133.1	6281439.0
2012-06-27 12:00:00	SPY	ETF	133.11	133.35	133.09	133.27	4666457.0
2012-06-27 12:30:00	SPY	ETF	133.27	133.32	133.15	133.22	2916109.0
2012-06-27 13:00:00	SPY	ETF	133.2197	133.33	133.05	133.07	4256677.0
2012-06-27 13:30:00	SPY	ETF	133.07	133.09	132.93	133.03	4258678.0
2012-06-27 14:00:00	SPY	ETF	133.04	133.08	132.83	132.895	4278242.0
2012-06-27 14:30:00	SPY	ETF	132.89	133.05	132.85	132.93	4177929.0
2012-06-27 15:00:00	SPY	ETF	132.92	133.33	132.89	133.25	6457635.0
2012-06-27 15:30:00	SPY	ETF	133.27	133.43	133.03	133.18	14827634.0
2012-06-27 16:00:00	SPY	ETF	133.17	133.2852	131.966	133.17	10572362.0
2012-06-27 16:30:00	SPY	ETF	133.16	133.26	133.11	133.16	121950.0
2012-06-27 17:00:00	SPY	ETF	133.14	133.16	133.07	133.07	51516.0
2012-06-27 17:30:00	SPY	ETF	133.09	133.11	133.07	133.1	8634.0
2012-06-27 18:00:00	SPY	ETF	133.08	133.19	133.08	133.19	10656.0
2012-06-27 18:30:00	SPY	ETF	133.17	133.17	133.07	133.1	39995.0
2012-06-27 19:00:00	SPY	ETF	133.1	133.1	133.07	133.09	8700.0
2012-06-27 19:30:00	SPY	ETF	133.08	133.08	133.01	133.05	37790.0
2012-06-27 20:00:00	SPY	ETF	133.04	133.04	133.03	133.03	9200.0
2012-06-27 07:00:00	QQQ	ETF	62.68	62.7	62.64	62.65	22100.0
2012-06-27 07:30:00	QQQ	ETF	62.65	62.7	62.65	62.7	49120.0
2012-06-27 08:00:00	QQQ	ETF	62.71	62.77	62.63	62.63	44025.0
2012-06-27 08:30:00	QQQ	ETF	62.7	62.71	62.6	62.61	107800.0
2012-06-27 09:00:00	QQQ	ETF	62.63	62.76	62.6	62.76	29365.0
2012-06-27 09:30:00	QQQ	ETF	62.75	62.955	62.6899	62.8	3770291.0
2012-06-27 10:00:00	QQQ	ETF	62.8	63.18	62.7599	63.06	4268321.0
2012-06-27 10:30:00	QQQ	ETF	63.06	63.0992	62.92	63.0499	2152849.0
2012-06-27 11:00:00	QQQ	ETF	63.049	63.12	62.91	62.96	2024552.0
2012-06-27 11:30:00	QQQ	ETF	62.96	63.11	62.96	63.02	1429907.0
2012-06-27 12:00:00	QQQ	ETF	63.02	63.15	63.0199	63.0999	1687484.0
2012-06-27 12:30:00	QQQ	ETF	63.0948	63.097	63.01	63.02	1010380.0
2012-06-27 13:00:00	QQQ	ETF	63.028	63.06	62.9	62.92	987741.0
2012-06-27 13:30:00	QQQ	ETF	62.91	62.91	62.7701	62.83	1441780.0
2012-06-27 14:00:00	QQQ	ETF	62.82	62.855	62.7	62.73	1177101.0
2012-06-27 14:30:00	QQQ	ETF	62.74	62.83	62.7	62.78	1219729.0
2012-06-27 15:00:00	QQQ	ETF	62.78	63.02	62.75	62.97	2008331.0
2012-06-27 15:30:00	QQQ	ETF	62.97	63.07	62.85	62.9099	4018299.0

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

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