PREVIEW / etf_30min / 2012-03-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-27.parquet
  size:    283 KB
  rows:    9,633

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-03-27 04:00:00	SPY	ETF	142.29	142.35	142.29	142.35	710.0
2012-03-27 04:30:00	SPY	ETF	142.3	142.3	142.25	142.25	200.0
2012-03-27 05:00:00	SPY	ETF	142.3	142.39	142.24	142.24	1800.0
2012-03-27 05:30:00	SPY	ETF	142.2	142.2	142.03	142.03	40308.0
2012-03-27 06:00:00	SPY	ETF	142.03	142.1	142.03	142.08	33500.0
2012-03-27 06:30:00	SPY	ETF	142.08	142.1	141.97	142.1	15200.0
2012-03-27 07:00:00	SPY	ETF	141.96	142.05	141.95	142.0	23139.0
2012-03-27 07:30:00	SPY	ETF	142.03	142.03	141.71	141.71	517416.0
2012-03-27 08:00:00	SPY	ETF	141.7	142.2	141.66	141.78	2135018.0
2012-03-27 08:30:00	SPY	ETF	141.78	141.96	141.72	141.85	1328058.0
2012-03-27 09:00:00	SPY	ETF	141.87	141.93	141.7	141.74	3364720.0
2012-03-27 09:30:00	SPY	ETF	141.74	141.83	141.63	141.78	11900149.0
2012-03-27 10:00:00	SPY	ETF	141.79	141.82	141.53	141.63	10753527.0
2012-03-27 10:30:00	SPY	ETF	141.64	141.73	141.45	141.475	10230694.0
2012-03-27 11:00:00	SPY	ETF	141.48	141.65	141.45	141.55	7555374.0
2012-03-27 11:30:00	SPY	ETF	141.55	141.64	141.46	141.63	4980842.0
2012-03-27 12:00:00	SPY	ETF	141.63	141.75	141.59	141.6	5009718.0
2012-03-27 12:30:00	SPY	ETF	141.6	141.66	141.511	141.64	3620646.0
2012-03-27 13:00:00	SPY	ETF	141.634	141.68	141.43	141.52	6136337.0
2012-03-27 13:30:00	SPY	ETF	141.5175	141.61	141.46	141.6	3185351.0
2012-03-27 14:00:00	SPY	ETF	141.6	141.72	141.56	141.705	3506998.0
2012-03-27 14:30:00	SPY	ETF	141.71	141.71	141.56	141.64	3379981.0
2012-03-27 15:00:00	SPY	ETF	141.63	141.71	141.35	141.38	5821643.0
2012-03-27 15:30:00	SPY	ETF	141.3806	141.47	141.08	141.16	16874957.0
2012-03-27 16:00:00	SPY	ETF	141.16	141.6738	141.04	141.08	12984048.0
2012-03-27 16:30:00	SPY	ETF	141.07	141.1188	141.01	141.04	1522647.0
2012-03-27 17:00:00	SPY	ETF	141.03	141.05	140.97	140.97	102183.0
2012-03-27 17:30:00	SPY	ETF	141.0	141.0	140.94	140.98	81562.0
2012-03-27 18:00:00	SPY	ETF	140.98	141.03	140.94	140.94	52203.0
2012-03-27 18:30:00	SPY	ETF	140.97	141.09	140.95	141.08	44196.0
2012-03-27 19:00:00	SPY	ETF	141.09	141.16	141.06	141.14	132700.0
2012-03-27 19:30:00	SPY	ETF	141.14	141.18	141.12	141.16	57915.0
2012-03-27 05:30:00	QQQ	ETF	68.22	68.22	68.22	68.22	1000.0
2012-03-27 07:00:00	QQQ	ETF	68.17	68.22	68.17	68.2	2940.0
2012-03-27 07:30:00	QQQ	ETF	68.17	68.18	68.09	68.09	10400.0
2012-03-27 08:00:00	QQQ	ETF	68.09	68.18	68.08	68.14	839045.0
2012-03-27 08:30:00	QQQ	ETF	68.14	68.24	68.12	68.16	85617.0
2012-03-27 09:00:00	QQQ	ETF	68.18	68.22	68.12	68.15	1280549.0
2012-03-27 09:30:00	QQQ	ETF	68.145	68.27	68.13	68.2	5634018.0
2012-03-27 10:00:00	QQQ	ETF	68.21	68.38	68.13	68.31	4118470.0
2012-03-27 10:30:00	QQQ	ETF	68.313	68.4	68.2105	68.2413	2661858.0
2012-03-27 11:00:00	QQQ	ETF	68.25	68.36	68.24	68.305	1517676.0
2012-03-27 11:30:00	QQQ	ETF	68.3015	68.34	68.26	68.328	1374173.0
2012-03-27 12:00:00	QQQ	ETF	68.33	68.39	68.321	68.36	1027423.0
2012-03-27 12:30:00	QQQ	ETF	68.3679	68.4	68.33	68.395	1260131.0
2012-03-27 13:00:00	QQQ	ETF	68.39	68.41	68.3	68.35	933568.0
2012-03-27 13:30:00	QQQ	ETF	68.35	68.45	68.33	68.43	1060916.0
2012-03-27 14:00:00	QQQ	ETF	68.43	68.48	68.4	68.4673	1301481.0
2012-03-27 14:30:00	QQQ	ETF	68.47	68.49	68.4	68.45	903260.0
2012-03-27 15:00:00	QQQ	ETF	68.45	68.49	68.26	68.26	2433247.0

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

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