PREVIEW / etf_30min / 2012-05-31

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-31.parquet
  size:    289 KB
  rows:    9,661

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-31 04:00:00	SPY	ETF	131.76	132.05	131.76	132.0	41988.0
2012-05-31 04:30:00	SPY	ETF	132.07	132.17	132.07	132.07	3379.0
2012-05-31 05:00:00	SPY	ETF	132.15	132.17	132.07	132.12	9234.0
2012-05-31 05:30:00	SPY	ETF	132.03	132.11	132.03	132.1	10800.0
2012-05-31 06:00:00	SPY	ETF	132.02	132.07	131.97	132.0	35200.0
2012-05-31 06:30:00	SPY	ETF	131.99	131.99	131.83	131.99	56998.0
2012-05-31 07:00:00	SPY	ETF	131.96	132.05	131.9	131.99	189930.0
2012-05-31 07:30:00	SPY	ETF	132.01	132.04	131.86	132.0	147231.0
2012-05-31 08:00:00	SPY	ETF	132.0	132.03	131.15	131.64	715557.0
2012-05-31 08:30:00	SPY	ETF	131.61	131.79	131.43	131.78	1187655.0
2012-05-31 09:00:00	SPY	ETF	131.78	131.78	131.59	131.71	554819.0
2012-05-31 09:30:00	SPY	ETF	131.71	131.87	130.795	130.97	25159491.0
2012-05-31 10:00:00	SPY	ETF	130.97	131.07	130.58	130.9	15204071.0
2012-05-31 10:30:00	SPY	ETF	130.905	131.04	130.48	130.62	13473560.0
2012-05-31 11:00:00	SPY	ETF	130.62	130.7	130.34	130.69	13811651.0
2012-05-31 11:30:00	SPY	ETF	130.68	131.12	130.61	130.84	12214224.0
2012-05-31 12:00:00	SPY	ETF	130.84	131.73	130.77	131.56	14314573.0
2012-05-31 12:30:00	SPY	ETF	131.57	131.66	131.28	131.47	9729948.0
2012-05-31 13:00:00	SPY	ETF	131.47	131.94	131.43	131.59	12282905.0
2012-05-31 13:30:00	SPY	ETF	131.58	131.7	131.2	131.31	10226733.0
2012-05-31 14:00:00	SPY	ETF	131.31	131.7	131.25	131.49	6979267.0
2012-05-31 14:30:00	SPY	ETF	131.48	131.74	131.42	131.63	6656875.0
2012-05-31 15:00:00	SPY	ETF	131.63	132.21	131.465	132.145	10454021.0
2012-05-31 15:30:00	SPY	ETF	132.135	132.45	131.47	131.53	26832620.0
2012-05-31 16:00:00	SPY	ETF	131.53	131.8163	131.15	131.21	12541234.0
2012-05-31 16:30:00	SPY	ETF	131.21	131.29	131.12	131.26	924166.0
2012-05-31 17:00:00	SPY	ETF	131.25	131.25	131.15	131.21	590294.0
2012-05-31 17:30:00	SPY	ETF	131.2	131.22	131.17	131.19	31160.0
2012-05-31 18:00:00	SPY	ETF	131.21	131.3	131.18	131.19	195445.0
2012-05-31 18:30:00	SPY	ETF	131.24	131.29	131.24	131.24	13250.0
2012-05-31 19:00:00	SPY	ETF	131.24	131.3	131.23	131.23	31117.0
2012-05-31 19:30:00	SPY	ETF	131.21	131.32	131.21	131.32	119609.0
2012-05-31 04:00:00	QQQ	ETF	62.37	62.37	62.37	62.37	100.0
2012-05-31 04:30:00	QQQ	ETF	62.4	62.41	62.4	62.41	2800.0
2012-05-31 05:30:00	QQQ	ETF	62.42	62.43	62.42	62.43	1270.0
2012-05-31 06:00:00	QQQ	ETF	62.41	62.41	62.41	62.41	300.0
2012-05-31 06:30:00	QQQ	ETF	62.31	62.34	62.31	62.34	1322.0
2012-05-31 07:00:00	QQQ	ETF	62.39	62.42	62.36	62.41	7610.0
2012-05-31 07:30:00	QQQ	ETF	62.37	62.41	62.34	62.35	1700.0
2012-05-31 08:00:00	QQQ	ETF	62.4	62.45	62.26	62.27	115519.0
2012-05-31 08:30:00	QQQ	ETF	62.2	62.34	62.12	62.32	151652.0
2012-05-31 09:00:00	QQQ	ETF	62.28	62.33	62.24	62.26	284678.0
2012-05-31 09:30:00	QQQ	ETF	62.26	62.32	61.785	61.85	8626559.0
2012-05-31 10:00:00	QQQ	ETF	61.85	61.93	61.59	61.7677	4876987.0
2012-05-31 10:30:00	QQQ	ETF	61.77	61.89	61.62	61.71	4770333.0
2012-05-31 11:00:00	QQQ	ETF	61.71	61.7701	61.59	61.77	3993628.0
2012-05-31 11:30:00	QQQ	ETF	61.76	61.98	61.74	61.82	3007359.0
2012-05-31 12:00:00	QQQ	ETF	61.8201	62.23	61.78	62.16	3621655.0
2012-05-31 12:30:00	QQQ	ETF	62.15	62.1914	62.015	62.0892	3186884.0
2012-05-31 13:00:00	QQQ	ETF	62.08	62.33	62.07	62.13	3159771.0

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

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