PREVIEW / etf_30min / 2012-08-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-08-23.parquet
  size:    281 KB
  rows:    9,554

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-08-23 04:00:00	SPY	ETF	142.24	142.24	142.0	142.0	1006.0
2012-08-23 04:30:00	SPY	ETF	142.04	142.04	142.04	142.04	1000.0
2012-08-23 05:00:00	SPY	ETF	142.09	142.29	142.09	142.29	1550.0
2012-08-23 05:30:00	SPY	ETF	142.25	142.25	142.25	142.25	200.0
2012-08-23 06:00:00	SPY	ETF	142.28	142.28	142.23	142.26	18000.0
2012-08-23 06:30:00	SPY	ETF	142.22	142.22	142.11	142.18	26005.0
2012-08-23 07:00:00	SPY	ETF	142.18	142.23	141.94	142.05	103546.0
2012-08-23 07:30:00	SPY	ETF	142.06	142.08	141.74	141.76	123320.0
2012-08-23 08:00:00	SPY	ETF	141.79	142.3	141.65	141.83	1428534.0
2012-08-23 08:30:00	SPY	ETF	141.74	142.39	141.4	141.45	1529871.0
2012-08-23 09:00:00	SPY	ETF	141.43	141.82	141.35	141.47	470164.0
2012-08-23 09:30:00	SPY	ETF	141.47	141.48	140.91	141.0	13095883.0
2012-08-23 10:00:00	SPY	ETF	140.99	141.17	140.8	141.065	13094166.0
2012-08-23 10:30:00	SPY	ETF	141.06	141.3	140.97	141.18	9079763.0
2012-08-23 11:00:00	SPY	ETF	141.18	141.33	140.98	141.27	7026377.0
2012-08-23 11:30:00	SPY	ETF	141.27	141.3	141.01	141.12	4611192.0
2012-08-23 12:00:00	SPY	ETF	141.13	141.15	140.78	140.931	7725704.0
2012-08-23 12:30:00	SPY	ETF	140.93	141.06	140.8	140.84	3807800.0
2012-08-23 13:00:00	SPY	ETF	140.83	140.85	140.44	140.53	6795473.0
2012-08-23 13:30:00	SPY	ETF	140.53	140.7013	140.49	140.65	3875752.0
2012-08-23 14:00:00	SPY	ETF	140.65	140.72	140.6	140.635	3382371.0
2012-08-23 14:30:00	SPY	ETF	140.64	140.9	140.61	140.76	8314819.0
2012-08-23 15:00:00	SPY	ETF	140.75	140.95	140.63	140.7596	7039542.0
2012-08-23 15:30:00	SPY	ETF	140.759	140.85	140.56	140.69	10643047.0
2012-08-23 16:00:00	SPY	ETF	140.68	141.2538	140.58	140.6	4137197.0
2012-08-23 16:30:00	SPY	ETF	140.6	141.7678	140.57	140.62	2349142.0
2012-08-23 17:00:00	SPY	ETF	140.66	140.78	140.65	140.75	277306.0
2012-08-23 17:30:00	SPY	ETF	140.73	140.75	140.67	140.7	29150.0
2012-08-23 18:00:00	SPY	ETF	140.71	140.79	140.7	140.77	32380.0
2012-08-23 18:30:00	SPY	ETF	140.79	140.8	140.75	140.78	10527.0
2012-08-23 19:00:00	SPY	ETF	140.78	140.81	140.78	140.8	19632.0
2012-08-23 19:30:00	SPY	ETF	140.78	140.79	140.73	140.77	29495.0
2012-08-23 04:30:00	QQQ	ETF	68.42	68.42	68.42	68.42	500.0
2012-08-23 05:00:00	QQQ	ETF	68.58	68.58	68.58	68.58	270.0
2012-08-23 07:00:00	QQQ	ETF	68.53	68.53	68.43	68.46	23129.0
2012-08-23 07:30:00	QQQ	ETF	68.45	68.49	68.31	68.34	35725.0
2012-08-23 08:00:00	QQQ	ETF	68.34	68.56	68.3	68.32	19750.0
2012-08-23 08:30:00	QQQ	ETF	68.3	68.3	68.14	68.18	131489.0
2012-08-23 09:00:00	QQQ	ETF	68.16	68.4	68.11	68.13	86512.0
2012-08-23 09:30:00	QQQ	ETF	68.14	68.15	67.84	67.89	3077717.0
2012-08-23 10:00:00	QQQ	ETF	67.89	68.01	67.72	67.91	3571113.0
2012-08-23 10:30:00	QQQ	ETF	67.91	68.13	67.88	68.072	2162786.0
2012-08-23 11:00:00	QQQ	ETF	68.08	68.34	68.0	68.3	1619972.0
2012-08-23 11:30:00	QQQ	ETF	68.31	68.31	68.05	68.118	820654.0
2012-08-23 12:00:00	QQQ	ETF	68.12	68.12	67.86	67.96	1475968.0
2012-08-23 12:30:00	QQQ	ETF	67.96	68.08	67.88	67.9175	1049106.0
2012-08-23 13:00:00	QQQ	ETF	67.9199	67.95	67.6905	67.78	1561655.0
2012-08-23 13:30:00	QQQ	ETF	67.78	67.91	67.74	67.89	1086471.0
2012-08-23 14:00:00	QQQ	ETF	67.89	67.95	67.83	67.9089	1079466.0
2012-08-23 14:30:00	QQQ	ETF	67.901	68.06	67.88	67.98	1093234.0

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

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