PREVIEW / etf_30min / 2012-02-02

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-02.parquet
  size:    286 KB
  rows:    9,724

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-02-02 04:00:00	SPY	ETF	132.5	132.5	132.34	132.34	51464.0
2012-02-02 04:30:00	SPY	ETF	132.4	132.43	132.32	132.33	29600.0
2012-02-02 05:00:00	SPY	ETF	132.48	132.49	132.38	132.38	13800.0
2012-02-02 05:30:00	SPY	ETF	132.51	132.67	132.51	132.54	34700.0
2012-02-02 06:00:00	SPY	ETF	132.46	132.53	132.44	132.53	21400.0
2012-02-02 06:30:00	SPY	ETF	132.6	132.6	132.47	132.49	2150.0
2012-02-02 07:00:00	SPY	ETF	137.0	137.0	132.17	132.36	146700.0
2012-02-02 07:30:00	SPY	ETF	132.35	132.37	132.19	132.26	185326.0
2012-02-02 08:00:00	SPY	ETF	132.29	132.38	132.22	132.35	488150.0
2012-02-02 08:30:00	SPY	ETF	132.36	132.64	132.33	132.57	840695.0
2012-02-02 09:00:00	SPY	ETF	132.57	132.74	132.49	132.74	857228.0
2012-02-02 09:30:00	SPY	ETF	132.73	132.8	132.37	132.61	15939681.0
2012-02-02 10:00:00	SPY	ETF	132.62	132.87	132.61	132.71	9534683.0
2012-02-02 10:30:00	SPY	ETF	132.71	133.02	132.69	132.88	8933519.0
2012-02-02 11:00:00	SPY	ETF	132.88	132.99	132.73	132.77	6780645.0
2012-02-02 11:30:00	SPY	ETF	132.76	132.77	132.49	132.59	8598256.0
2012-02-02 12:00:00	SPY	ETF	132.58	132.64	132.34	132.4601	7066207.0
2012-02-02 12:30:00	SPY	ETF	132.47	132.52	132.21	132.5	5417427.0
2012-02-02 13:00:00	SPY	ETF	132.51	132.58	132.42	132.43	5462211.0
2012-02-02 13:30:00	SPY	ETF	132.421	132.7	132.4	132.6389	4531838.0
2012-02-02 14:00:00	SPY	ETF	132.635	132.69	132.58	132.64	3408533.0
2012-02-02 14:30:00	SPY	ETF	132.635	132.73	132.52	132.635	6386103.0
2012-02-02 15:00:00	SPY	ETF	132.634	132.73	132.6	132.66	6375655.0
2012-02-02 15:30:00	SPY	ETF	132.665	132.83	132.59	132.67	12606186.0
2012-02-02 16:00:00	SPY	ETF	132.69	132.86	132.6496	132.72	6088758.0
2012-02-02 16:30:00	SPY	ETF	132.73	132.7991	132.69	132.75	331673.0
2012-02-02 17:00:00	SPY	ETF	132.73	132.76	132.621	132.7	222387.0
2012-02-02 17:30:00	SPY	ETF	132.73	132.77	132.72	132.72	29016.0
2012-02-02 18:00:00	SPY	ETF	132.72	132.74	132.67	132.67	61844.0
2012-02-02 18:30:00	SPY	ETF	132.72	132.79	132.71	132.71	16144.0
2012-02-02 19:00:00	SPY	ETF	132.71	132.74	132.67	132.74	28070.0
2012-02-02 19:30:00	SPY	ETF	132.72	132.8	132.69	132.8	74452.0
2012-02-02 04:00:00	QQQ	ETF	61.03	61.03	61.03	61.03	700.0
2012-02-02 05:30:00	QQQ	ETF	61.17	61.17	61.07	61.07	500.0
2012-02-02 06:30:00	QQQ	ETF	61.09	61.09	61.07	61.07	1547.0
2012-02-02 07:00:00	QQQ	ETF	61.05	61.05	60.89	60.95	201385.0
2012-02-02 07:30:00	QQQ	ETF	60.99	61.06	60.96	60.99	7500.0
2012-02-02 08:00:00	QQQ	ETF	61.01	61.05	60.98	61.05	55885.0
2012-02-02 08:30:00	QQQ	ETF	61.05	61.17	61.05	61.15	86545.0
2012-02-02 09:00:00	QQQ	ETF	61.14	61.22	61.13	61.21	162676.0
2012-02-02 09:30:00	QQQ	ETF	61.2	61.24	61.12	61.226	3993241.0
2012-02-02 10:00:00	QQQ	ETF	61.222	61.33	61.21	61.27	3961104.0
2012-02-02 10:30:00	QQQ	ETF	61.26	61.41	61.26	61.35	2579708.0
2012-02-02 11:00:00	QQQ	ETF	61.35	61.41	61.26	61.2817	2846245.0
2012-02-02 11:30:00	QQQ	ETF	61.28	61.3	61.16	61.2326	2826200.0
2012-02-02 12:00:00	QQQ	ETF	61.24	61.252	61.11	61.13	1849854.0
2012-02-02 12:30:00	QQQ	ETF	61.14	61.14	60.97	61.12	1727855.0
2012-02-02 13:00:00	QQQ	ETF	61.12	61.14	61.03	61.03	1412822.0
2012-02-02 13:30:00	QQQ	ETF	61.03	61.17	61.02	61.12	2728024.0
2012-02-02 14:00:00	QQQ	ETF	61.12	61.21	61.11	61.146	2053691.0

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

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