PREVIEW / etf_30min / 2012-10-26

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-26.parquet
  size:    280 KB
  rows:    9,428

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-10-26 04:00:00	SPY	ETF	140.4	140.48	140.3	140.34	34185.0
2012-10-26 04:30:00	SPY	ETF	140.43	140.59	140.42	140.48	6990.0
2012-10-26 05:00:00	SPY	ETF	140.52	140.55	140.38	140.38	48525.0
2012-10-26 05:30:00	SPY	ETF	140.39	140.46	140.33	140.42	47430.0
2012-10-26 06:00:00	SPY	ETF	140.37	140.37	140.28	140.37	8850.0
2012-10-26 06:30:00	SPY	ETF	140.34	140.39	140.21	140.31	147830.0
2012-10-26 07:00:00	SPY	ETF	140.3	140.46	140.25	140.4	618647.0
2012-10-26 07:30:00	SPY	ETF	140.38	140.67	140.29	140.61	263807.0
2012-10-26 08:00:00	SPY	ETF	140.61	140.93	140.25	140.82	1091851.0
2012-10-26 08:30:00	SPY	ETF	140.85	141.68	140.53	141.35	2881722.0
2012-10-26 09:00:00	SPY	ETF	141.34	141.41	141.15	141.29	1141529.0
2012-10-26 09:30:00	SPY	ETF	141.3	141.78	141.18	141.2	14242385.0
2012-10-26 10:00:00	SPY	ETF	141.19	141.55	141.02	141.03	11680469.0
2012-10-26 10:30:00	SPY	ETF	141.02	141.22	140.65	140.82	10027554.0
2012-10-26 11:00:00	SPY	ETF	140.83	141.09	140.68	141.05	6153765.0
2012-10-26 11:30:00	SPY	ETF	141.05	141.4021	140.75	140.8	13541288.0
2012-10-26 12:00:00	SPY	ETF	140.8	140.8006	140.39	140.768	8894033.0
2012-10-26 12:30:00	SPY	ETF	140.76	140.94	140.5	140.91	6324295.0
2012-10-26 13:00:00	SPY	ETF	140.92	140.96	140.66	140.921	6002465.0
2012-10-26 13:30:00	SPY	ETF	140.92	141.38	140.86	141.25	8181633.0
2012-10-26 14:00:00	SPY	ETF	141.24	141.4	141.13	141.33	4238204.0
2012-10-26 14:30:00	SPY	ETF	141.33	141.59	141.28	141.3975	6482195.0
2012-10-26 15:00:00	SPY	ETF	141.39	141.75	141.36	141.72	5948900.0
2012-10-26 15:30:00	SPY	ETF	141.72	141.84	141.19	141.3	17677958.0
2012-10-26 16:00:00	SPY	ETF	141.3	141.6	141.25	141.31	7725477.0
2012-10-26 16:30:00	SPY	ETF	141.31	141.37	141.0929	141.23	11638193.0
2012-10-26 17:00:00	SPY	ETF	141.24	141.33	141.2	141.3	80580.0
2012-10-26 17:30:00	SPY	ETF	141.31	141.31	141.18	141.24	116496.0
2012-10-26 18:00:00	SPY	ETF	141.25	141.26	141.23	141.23	2460.0
2012-10-26 18:30:00	SPY	ETF	141.22	141.23	141.21	141.21	2350.0
2012-10-26 19:00:00	SPY	ETF	141.2	141.21	141.19	141.19	6208.0
2012-10-26 19:30:00	SPY	ETF	141.19	141.26	141.19	141.2	10545.0
2012-10-26 04:00:00	QQQ	ETF	64.66	64.66	64.59	64.59	15601.0
2012-10-26 04:30:00	QQQ	ETF	64.62	64.71	64.62	64.65	450.0
2012-10-26 05:30:00	QQQ	ETF	64.72	64.74	64.72	64.74	300.0
2012-10-26 06:00:00	QQQ	ETF	64.62	64.62	64.62	64.62	2500.0
2012-10-26 06:30:00	QQQ	ETF	64.7	64.7	64.63	64.7	2800.0
2012-10-26 07:00:00	QQQ	ETF	64.73	64.85	64.73	64.84	24600.0
2012-10-26 07:30:00	QQQ	ETF	64.83	65.0	64.81	64.98	468595.0
2012-10-26 08:00:00	QQQ	ETF	64.97	65.09	64.76	65.01	2419172.0
2012-10-26 08:30:00	QQQ	ETF	65.07	65.6	65.0	65.14	2755001.0
2012-10-26 09:00:00	QQQ	ETF	65.14	65.26	64.77	65.16	1680741.0
2012-10-26 09:30:00	QQQ	ETF	65.17	65.57	65.06	65.31	8530742.0
2012-10-26 10:00:00	QQQ	ETF	65.32	65.51	65.2	65.2	3467692.0
2012-10-26 10:30:00	QQQ	ETF	65.2	65.3	64.97	64.99	2772347.0
2012-10-26 11:00:00	QQQ	ETF	64.9914	65.13	64.87	65.11	2638791.0
2012-10-26 11:30:00	QQQ	ETF	65.1	65.16	64.91	64.94	1948119.0
2012-10-26 12:00:00	QQQ	ETF	64.93	64.93	64.65	64.82	3470780.0
2012-10-26 12:30:00	QQQ	ETF	64.82	64.99	64.71	64.965	2000673.0
2012-10-26 13:00:00	QQQ	ETF	64.97	65.01	64.83	64.97	1216121.0

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

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