PREVIEW / etf_30min / 2012-05-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-15.parquet
  size:    293 KB
  rows:    9,938

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-05-15 04:00:00	SPY	ETF	134.85	135.11	134.74	134.8	28510.0
2012-05-15 04:30:00	SPY	ETF	134.74	134.74	134.59	134.59	839.0
2012-05-15 05:00:00	SPY	ETF	134.66	134.83	134.66	134.78	1590.0
2012-05-15 05:30:00	SPY	ETF	134.8	134.8	134.59	134.65	38650.0
2012-05-15 06:00:00	SPY	ETF	134.88	134.88	134.82	134.88	25940.0
2012-05-15 06:30:00	SPY	ETF	134.82	134.83	134.61	134.64	149115.0
2012-05-15 07:00:00	SPY	ETF	134.64	134.69	134.51	134.58	111016.0
2012-05-15 07:30:00	SPY	ETF	134.57	134.75	134.54	134.75	90676.0
2012-05-15 08:00:00	SPY	ETF	134.75	134.83	134.58	134.65	615446.0
2012-05-15 08:30:00	SPY	ETF	134.68	134.97	134.25	134.26	2026941.0
2012-05-15 09:00:00	SPY	ETF	134.26	134.36	133.61	134.02	6170789.0
2012-05-15 09:30:00	SPY	ETF	134.02	134.47	133.94	134.26	22103101.0
2012-05-15 10:00:00	SPY	ETF	134.265	134.72	134.1	134.68	14720010.0
2012-05-15 10:30:00	SPY	ETF	134.68	134.7	134.31	134.35	12156411.0
2012-05-15 11:00:00	SPY	ETF	134.36	134.38	133.84	134.0	13258211.0
2012-05-15 11:30:00	SPY	ETF	134.0	134.7	133.98	134.595	9928379.0
2012-05-15 12:00:00	SPY	ETF	134.6	134.81	134.52	134.695	7206261.0
2012-05-15 12:30:00	SPY	ETF	134.7	134.75	134.36	134.4	5177939.0
2012-05-15 13:00:00	SPY	ETF	134.4	134.55	134.39	134.475	6760050.0
2012-05-15 13:30:00	SPY	ETF	134.47	134.47	133.92	134.0025	10160102.0
2012-05-15 14:00:00	SPY	ETF	134.01	134.37	133.98	134.25	9691298.0
2012-05-15 14:30:00	SPY	ETF	134.26	134.33	133.89	133.935	10637412.0
2012-05-15 15:00:00	SPY	ETF	133.922	134.1358	133.13	133.17	27435372.0
2012-05-15 15:30:00	SPY	ETF	133.18	133.67	133.17	133.36	28293175.0
2012-05-15 16:00:00	SPY	ETF	133.35	133.55	133.32	133.44	15717175.0
2012-05-15 16:30:00	SPY	ETF	133.45	133.61	133.35	133.51	1120462.0
2012-05-15 17:00:00	SPY	ETF	133.51	133.58	133.48	133.58	90755.0
2012-05-15 17:30:00	SPY	ETF	133.56	133.57	133.52	133.56	49355.0
2012-05-15 18:00:00	SPY	ETF	133.57	133.75	133.57	133.62	230799.0
2012-05-15 18:30:00	SPY	ETF	133.59	133.64	133.52	133.63	57795.0
2012-05-15 19:00:00	SPY	ETF	133.63	133.68	133.6	133.68	36500.0
2012-05-15 19:30:00	SPY	ETF	133.66	133.73	133.63	133.68	48683.0
2012-05-15 04:00:00	QQQ	ETF	64.0	64.0	64.0	64.0	100.0
2012-05-15 05:30:00	QQQ	ETF	63.95	63.95	63.95	63.95	500.0
2012-05-15 06:00:00	QQQ	ETF	64.04	64.04	64.04	64.04	4000.0
2012-05-15 06:30:00	QQQ	ETF	63.97	63.98	63.93	63.93	2600.0
2012-05-15 07:00:00	QQQ	ETF	63.93	63.94	63.87	63.87	39000.0
2012-05-15 07:30:00	QQQ	ETF	63.87	63.98	63.86	63.98	152605.0
2012-05-15 08:00:00	QQQ	ETF	63.98	64.03	63.9	63.91	180242.0
2012-05-15 08:30:00	QQQ	ETF	63.93	64.08	63.78	63.78	256913.0
2012-05-15 09:00:00	QQQ	ETF	63.78	63.83	63.58	63.77	591484.0
2012-05-15 09:30:00	QQQ	ETF	63.79	63.91	63.6	63.77	4946519.0
2012-05-15 10:00:00	QQQ	ETF	63.77	64.06	63.63	64.04	6390306.0
2012-05-15 10:30:00	QQQ	ETF	64.04	64.05	63.9	63.95	7027885.0
2012-05-15 11:00:00	QQQ	ETF	63.95	63.965	63.66	63.755	3900316.0
2012-05-15 11:30:00	QQQ	ETF	63.74	64.15	63.7399	64.065	3431072.0
2012-05-15 12:00:00	QQQ	ETF	64.07	64.27	64.05	64.2242	3340007.0
2012-05-15 12:30:00	QQQ	ETF	64.23	64.25	64.03	64.06	1632424.0
2012-05-15 13:00:00	QQQ	ETF	64.06	64.14	64.05	64.11	1037837.0
2012-05-15 13:30:00	QQQ	ETF	64.11	64.11	63.77	63.86	2290564.0

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

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