PREVIEW / etf_30min / 2012-12-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-27.parquet
  size:    305 KB
  rows:    10,182

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-12-27 04:00:00	SPY	ETF	141.64	141.66	141.64	141.66	2950.0
2012-12-27 04:30:00	SPY	ETF	141.65	141.65	141.64	141.64	41400.0
2012-12-27 05:00:00	SPY	ETF	141.69	141.73	141.69	141.73	21350.0
2012-12-27 05:30:00	SPY	ETF	141.67	141.7	141.6	141.7	1720.0
2012-12-27 06:00:00	SPY	ETF	141.72	141.83	141.72	141.81	20767.0
2012-12-27 06:30:00	SPY	ETF	141.8	141.98	141.75	141.95	64381.0
2012-12-27 07:00:00	SPY	ETF	141.97	142.08	141.97	142.05	18458.0
2012-12-27 07:30:00	SPY	ETF	142.07	142.08	141.89	141.92	53402.0
2012-12-27 08:00:00	SPY	ETF	141.92	142.08	141.67	141.88	278225.0
2012-12-27 08:30:00	SPY	ETF	141.92	141.93	141.76	141.86	656005.0
2012-12-27 09:00:00	SPY	ETF	141.85	141.87	141.73	141.81	338202.0
2012-12-27 09:30:00	SPY	ETF	141.79	142.08	141.6	141.729	9200482.0
2012-12-27 10:00:00	SPY	ETF	141.72	141.72	140.61	140.791	19057479.0
2012-12-27 10:30:00	SPY	ETF	140.79	141.02	140.61	140.87	10072539.0
2012-12-27 11:00:00	SPY	ETF	140.86	141.01	140.47	140.66	11105433.0
2012-12-27 11:30:00	SPY	ETF	140.655	140.87	140.47	140.57	5499955.0
2012-12-27 12:00:00	SPY	ETF	140.575	140.6	140.22	140.2984	7725831.0
2012-12-27 12:30:00	SPY	ETF	140.2901	140.39	139.92	140.38	10968237.0
2012-12-27 13:00:00	SPY	ETF	140.39	141.7498	140.19	140.26	9170641.0
2012-12-27 13:30:00	SPY	ETF	140.26	140.74	140.17	140.26	5746728.0
2012-12-27 14:00:00	SPY	ETF	140.26	140.38	140.095	140.17	7138636.0
2012-12-27 14:30:00	SPY	ETF	140.18	141.1	140.06	140.99	19122955.0
2012-12-27 15:00:00	SPY	ETF	141.0	141.54	140.87	141.35	15127223.0
2012-12-27 15:30:00	SPY	ETF	141.34	141.92	141.33	141.5899	23256828.0
2012-12-27 16:00:00	SPY	ETF	141.57	141.6839	140.7612	141.46	9990795.0
2012-12-27 16:30:00	SPY	ETF	141.45	141.72	141.43	141.69	1035858.0
2012-12-27 17:00:00	SPY	ETF	141.69	141.74	141.57	141.59	200953.0
2012-12-27 17:30:00	SPY	ETF	141.58	141.64	141.49	141.64	152735.0
2012-12-27 18:00:00	SPY	ETF	141.61	141.93	141.61	141.91	110145.0
2012-12-27 18:30:00	SPY	ETF	141.89	141.92	141.74	141.74	47902.0
2012-12-27 19:00:00	SPY	ETF	141.76	141.76	141.66	141.68	12900.0
2012-12-27 19:30:00	SPY	ETF	141.66	141.75	141.65	141.72	28838.0
2012-12-27 06:00:00	QQQ	ETF	64.57	64.62	64.57	64.62	6800.0
2012-12-27 07:00:00	QQQ	ETF	64.62	64.64	64.6	64.64	740.0
2012-12-27 07:30:00	QQQ	ETF	64.64	64.64	64.6	64.6	7700.0
2012-12-27 08:00:00	QQQ	ETF	64.62	64.62	64.56	64.58	30655.0
2012-12-27 08:30:00	QQQ	ETF	64.59	64.6	64.54	64.59	142268.0
2012-12-27 09:00:00	QQQ	ETF	64.58	64.6	64.56	64.56	34815.0
2012-12-27 09:30:00	QQQ	ETF	64.54	64.58	64.36	64.48	4118611.0
2012-12-27 10:00:00	QQQ	ETF	64.48	64.481	63.97	64.06	3944513.0
2012-12-27 10:30:00	QQQ	ETF	64.05	64.23	63.95	64.17	2194823.0
2012-12-27 11:00:00	QQQ	ETF	64.18	64.27	64.01	64.07	1862181.0
2012-12-27 11:30:00	QQQ	ETF	64.07	64.13	63.86	63.9	2138719.0
2012-12-27 12:00:00	QQQ	ETF	63.91	63.94	63.76	63.81	2468871.0
2012-12-27 12:30:00	QQQ	ETF	63.81	63.81	63.6	63.8	2733570.0
2012-12-27 13:00:00	QQQ	ETF	63.8	64.0	63.78	63.83	3672764.0
2012-12-27 13:30:00	QQQ	ETF	63.84	63.89	63.76	63.79	1233250.0
2012-12-27 14:00:00	QQQ	ETF	63.785	63.86	63.71	63.75	1447311.0
2012-12-27 14:30:00	QQQ	ETF	63.75	64.2	63.701	64.17	3637999.0
2012-12-27 15:00:00	QQQ	ETF	64.18	64.489	64.13	64.36	3537940.0

> showing 50 of 10,182 rows — these rows as CSV

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