PREVIEW / etf_30min / 2012-05-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-02.parquet
  size:    276 KB
  rows:    9,533

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-02 04:00:00	SPY	ETF	140.5	140.63	140.46	140.6	72725.0
2012-05-02 04:30:00	SPY	ETF	140.58	140.58	140.5	140.5	6879.0
2012-05-02 05:00:00	SPY	ETF	140.66	140.67	140.43	140.44	10950.0
2012-05-02 05:30:00	SPY	ETF	140.43	140.43	140.31	140.39	4767.0
2012-05-02 06:00:00	SPY	ETF	140.42	140.42	140.42	140.42	200.0
2012-05-02 06:30:00	SPY	ETF	140.39	140.46	140.18	140.19	14251.0
2012-05-02 07:00:00	SPY	ETF	140.2	140.31	140.11	140.22	1050807.0
2012-05-02 07:30:00	SPY	ETF	140.24	140.3	140.18	140.2	364581.0
2012-05-02 08:00:00	SPY	ETF	140.21	140.23	139.72	139.91	2447955.0
2012-05-02 08:30:00	SPY	ETF	139.9	139.98	139.75	139.79	1551104.0
2012-05-02 09:00:00	SPY	ETF	139.79	139.96	139.75	139.92	883434.0
2012-05-02 09:30:00	SPY	ETF	139.92	140.06	139.77	139.905	15783583.0
2012-05-02 10:00:00	SPY	ETF	139.91	139.98	139.52	139.59	13022504.0
2012-05-02 10:30:00	SPY	ETF	139.58	140.1	139.46	139.99	10601573.0
2012-05-02 11:00:00	SPY	ETF	139.99	140.07	139.88	139.98	6934882.0
2012-05-02 11:30:00	SPY	ETF	139.97	140.11	139.94	139.966	6044093.0
2012-05-02 12:00:00	SPY	ETF	139.97	140.33	139.9	140.25	7567645.0
2012-05-02 12:30:00	SPY	ETF	140.26	140.34	140.17	140.225	4669609.0
2012-05-02 13:00:00	SPY	ETF	140.23	140.27	140.01	140.04	6105274.0
2012-05-02 13:30:00	SPY	ETF	140.04	140.32	140.03	140.27	4718552.0
2012-05-02 14:00:00	SPY	ETF	140.26	140.46	140.21	140.45	5949397.0
2012-05-02 14:30:00	SPY	ETF	140.455	140.46	140.24	140.26	5278545.0
2012-05-02 15:00:00	SPY	ETF	140.26	140.32	140.05	140.19	6535403.0
2012-05-02 15:30:00	SPY	ETF	140.19	140.46	140.1	140.34	10247810.0
2012-05-02 16:00:00	SPY	ETF	140.33	140.6973	139.9426	140.26	5535069.0
2012-05-02 16:30:00	SPY	ETF	140.26	140.33	140.22	140.32	172643.0
2012-05-02 17:00:00	SPY	ETF	140.32	140.32	140.26	140.26	58400.0
2012-05-02 17:30:00	SPY	ETF	140.27	140.29	140.23	140.26	14249.0
2012-05-02 18:00:00	SPY	ETF	140.27	140.31	140.24	140.31	24209.0
2012-05-02 18:30:00	SPY	ETF	140.3	140.35	140.28	140.32	47057.0
2012-05-02 19:00:00	SPY	ETF	140.31	140.36	140.3	140.34	7050.0
2012-05-02 19:30:00	SPY	ETF	140.35	140.36	140.29	140.3	20170.0
2012-05-02 04:00:00	QQQ	ETF	66.76	66.76	66.76	66.76	150.0
2012-05-02 05:00:00	QQQ	ETF	66.8	66.8	66.8	66.8	2000.0
2012-05-02 06:00:00	QQQ	ETF	66.69	66.7	66.69	66.7	2000.0
2012-05-02 06:30:00	QQQ	ETF	66.68	66.68	66.63	66.64	14200.0
2012-05-02 07:00:00	QQQ	ETF	66.65	66.67	66.59	66.61	129137.0
2012-05-02 07:30:00	QQQ	ETF	66.64	66.65	66.61	66.64	86215.0
2012-05-02 08:00:00	QQQ	ETF	66.62	66.63	66.39	66.47	1267157.0
2012-05-02 08:30:00	QQQ	ETF	66.49	66.53	66.4	66.42	118110.0
2012-05-02 09:00:00	QQQ	ETF	66.42	66.51	66.4	66.5	304346.0
2012-05-02 09:30:00	QQQ	ETF	66.5	66.77	66.41	66.73	6202326.0
2012-05-02 10:00:00	QQQ	ETF	66.73	66.77	66.45	66.47	3806224.0
2012-05-02 10:30:00	QQQ	ETF	66.46	66.7	66.38	66.68	2693665.0
2012-05-02 11:00:00	QQQ	ETF	66.68	66.78	66.61	66.78	2835190.0
2012-05-02 11:30:00	QQQ	ETF	66.78	66.91	66.7501	66.8	2037964.0
2012-05-02 12:00:00	QQQ	ETF	66.81	67.02	66.76	66.98	1627505.0
2012-05-02 12:30:00	QQQ	ETF	66.975	67.02	66.89	66.94	1719510.0
2012-05-02 13:00:00	QQQ	ETF	66.94	66.9783	66.8	66.81	803983.0
2012-05-02 13:30:00	QQQ	ETF	66.81	67.0	66.81	66.96	950336.0

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

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