PREVIEW / stock_30min / 2013-01-04

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-01-04.parquet
  size:    1.4 MB
  rows:    74,998
  symbols: 3,460

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
2013-01-04 04:00:00	AAPL	Stock	19.3361	19.3714	19.3361	19.3714	8400.0
2013-01-04 04:30:00	AAPL	Stock	19.3714	19.3714	19.3714	19.3714	2800.0
2013-01-04 05:00:00	AAPL	Stock	19.3821	19.3821	19.3821	19.3821	2800.0
2013-01-04 06:00:00	AAPL	Stock	19.3929	19.3929	19.3929	19.3929	5600.0
2013-01-04 07:00:00	AAPL	Stock	19.3875	19.4296	19.3875	19.4164	44128.0
2013-01-04 07:30:00	AAPL	Stock	19.4107	19.4371	19.4071	19.4071	216412.0
2013-01-04 08:00:00	AAPL	Stock	19.4071	19.4464	19.3768	19.4464	1168860.0
2013-01-04 08:30:00	AAPL	Stock	19.4443	19.4521	19.1764	19.2032	6743380.0
2013-01-04 09:00:00	AAPL	Stock	19.1946	19.2079	19.1536	19.1696	4308640.0
2013-01-04 09:30:00	AAPL	Stock	19.1725	19.2368	19.1143	19.1389	71084888.0
2013-01-04 10:00:00	AAPL	Stock	19.1414	19.1564	18.8629	18.9074	101364200.0
2013-01-04 10:30:00	AAPL	Stock	18.9075	18.9157	18.8146	18.82	62606180.0
2013-01-04 11:00:00	AAPL	Stock	18.8268	18.8671	18.7932	18.8036	33198592.0
2013-01-04 11:30:00	AAPL	Stock	18.8036	18.9214	18.7904	18.9029	36999144.0
2013-01-04 12:00:00	AAPL	Stock	18.9029	19.0168	18.8689	19.0071	42690228.0
2013-01-04 12:30:00	AAPL	Stock	19.0036	19.0079	18.9039	18.9214	22176616.0
2013-01-04 13:00:00	AAPL	Stock	18.9219	18.9786	18.9161	18.9207	18394880.0
2013-01-04 13:30:00	AAPL	Stock	18.9239	18.925	18.84	18.8519	26247116.0
2013-01-04 14:00:00	AAPL	Stock	18.8518	18.9014	18.8286	18.8775	25659480.0
2013-01-04 14:30:00	AAPL	Stock	18.8784	18.9271	18.8539	18.9236	19875688.0
2013-01-04 15:00:00	AAPL	Stock	18.9204	18.9679	18.9004	18.9493	39019092.0
2013-01-04 15:30:00	AAPL	Stock	18.9479	18.9568	18.8021	18.8218	64375416.0
2013-01-04 16:00:00	AAPL	Stock	18.8186	19.1786	18.7675	18.7832	9449076.0
2013-01-04 16:30:00	AAPL	Stock	18.7789	18.9452	18.7686	18.7704	829836.0
2013-01-04 17:00:00	AAPL	Stock	18.7707	18.7804	18.7625	18.7768	244860.0
2013-01-04 17:30:00	AAPL	Stock	18.7814	18.7818	18.7732	18.7732	99512.0
2013-01-04 18:00:00	AAPL	Stock	18.7796	18.7814	18.7743	18.7757	114856.0
2013-01-04 18:30:00	AAPL	Stock	18.7768	18.7796	18.7675	18.7764	209748.0
2013-01-04 19:00:00	AAPL	Stock	18.7679	18.7768	18.7525	18.7536	173152.0
2013-01-04 19:30:00	AAPL	Stock	18.7621	18.7654	18.7518	18.7571	233184.0
2013-01-04 06:30:00	MSFT	Stock	27.3	27.3	27.3	27.3	100.0
2013-01-04 07:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	700.0
2013-01-04 07:30:00	MSFT	Stock	27.28	27.39	27.26	27.3	3403.0
2013-01-04 08:00:00	MSFT	Stock	27.3	27.3	27.24	27.3	19222.0
2013-01-04 08:30:00	MSFT	Stock	27.3	27.32	27.22	27.26	17466.0
2013-01-04 09:00:00	MSFT	Stock	27.25	27.27	27.23	27.26	18950.0
2013-01-04 09:30:00	MSFT	Stock	27.27	27.34	27.02	27.06	4990395.0
2013-01-04 10:00:00	MSFT	Stock	27.06	27.09	26.96	27.01	4460605.0
2013-01-04 10:30:00	MSFT	Stock	27.02	27.03	26.82	26.855	5459251.0
2013-01-04 11:00:00	MSFT	Stock	26.86	26.97	26.85	26.91	3005403.0
2013-01-04 11:30:00	MSFT	Stock	26.91	26.95	26.88	26.92	3313217.0
2013-01-04 12:00:00	MSFT	Stock	26.91	26.94	26.88	26.9	2195756.0
2013-01-04 12:30:00	MSFT	Stock	26.9	26.93	26.88	26.89	2123008.0
2013-01-04 13:00:00	MSFT	Stock	26.88	26.9	26.86	26.9	2084697.0
2013-01-04 13:30:00	MSFT	Stock	26.9	26.93	26.855	26.865	1877459.0
2013-01-04 14:00:00	MSFT	Stock	26.87	26.9	26.86	26.86	1957463.0
2013-01-04 14:30:00	MSFT	Stock	26.868	26.88	26.82	26.845	2728160.0
2013-01-04 15:00:00	MSFT	Stock	26.85	26.89	26.83	26.89	2859809.0
2013-01-04 15:30:00	MSFT	Stock	26.888	26.89	26.73	26.76	11402285.0
2013-01-04 16:00:00	MSFT	Stock	26.75	26.948	26.74	26.74	3074379.0

> showing 50 of 74,998 rows — these rows as CSV

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