PREVIEW / stock_30min / 2012-01-19

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-19.parquet
  size:    1.4 MB
  rows:    74,990
  symbols: 3,499

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-01-19 05:30:00	AAPL	Stock	15.3861	15.3861	15.3861	15.3861	5600.0
2012-01-19 06:00:00	AAPL	Stock	15.3771	15.3857	15.375	15.375	14000.0
2012-01-19 06:30:00	AAPL	Stock	15.3829	15.3857	15.3714	15.3714	42000.0
2012-01-19 07:00:00	AAPL	Stock	15.3714	15.3968	15.3607	15.3768	209160.0
2012-01-19 07:30:00	AAPL	Stock	15.3821	15.3968	15.3714	15.3761	315700.0
2012-01-19 08:00:00	AAPL	Stock	15.375	15.3929	15.3132	15.3654	1014104.0
2012-01-19 08:30:00	AAPL	Stock	15.375	15.3857	15.3643	15.37	751072.0
2012-01-19 09:00:00	AAPL	Stock	15.37	15.3907	15.3571	15.3571	1888964.0
2012-01-19 09:30:00	AAPL	Stock	15.3625	15.406	15.3179	15.3336	53116140.0
2012-01-19 10:00:00	AAPL	Stock	15.3311	15.3432	15.2929	15.3264	32450936.0
2012-01-19 10:30:00	AAPL	Stock	15.3264	15.356	15.3043	15.3417	16805040.0
2012-01-19 11:00:00	AAPL	Stock	15.3429	15.36	15.34	15.3544	14386960.0
2012-01-19 11:30:00	AAPL	Stock	15.3564	15.3579	15.3214	15.3336	13530720.0
2012-01-19 12:00:00	AAPL	Stock	15.3334	15.3461	15.3275	15.3354	6979588.0
2012-01-19 12:30:00	AAPL	Stock	15.3356	15.3356	15.3121	15.3179	10443664.0
2012-01-19 13:00:00	AAPL	Stock	15.3168	15.3314	15.315	15.3254	6933024.0
2012-01-19 13:30:00	AAPL	Stock	15.3243	15.3371	15.3214	15.3311	6569612.0
2012-01-19 14:00:00	AAPL	Stock	15.3318	15.3489	15.3293	15.3421	9791096.0
2012-01-19 14:30:00	AAPL	Stock	15.3415	15.3426	15.3157	15.3232	10116568.0
2012-01-19 15:00:00	AAPL	Stock	15.3218	15.3336	15.3057	15.3079	12467532.0
2012-01-19 15:30:00	AAPL	Stock	15.3079	15.3132	15.2325	15.2725	40606216.0
2012-01-19 16:00:00	AAPL	Stock	15.2725	15.3396	15.1625	15.2314	18216884.0
2012-01-19 16:30:00	AAPL	Stock	15.2386	15.3065	15.22	15.2321	1032248.0
2012-01-19 17:00:00	AAPL	Stock	15.2321	15.2446	15.2214	15.2257	444360.0
2012-01-19 17:30:00	AAPL	Stock	15.2271	15.2286	15.22	15.2204	398132.0
2012-01-19 18:00:00	AAPL	Stock	15.2221	15.2768	15.22	15.2286	190904.0
2012-01-19 18:30:00	AAPL	Stock	15.2239	15.2282	15.2207	15.225	140224.0
2012-01-19 19:00:00	AAPL	Stock	15.2268	15.2268	15.2171	15.2171	183372.0
2012-01-19 19:30:00	AAPL	Stock	15.2168	15.2182	15.2143	15.2182	100688.0
2012-01-19 07:00:00	MSFT	Stock	28.21	28.24	28.18	28.24	5600.0
2012-01-19 07:30:00	MSFT	Stock	28.2	28.3	28.2	28.3	13100.0
2012-01-19 08:00:00	MSFT	Stock	28.3	28.32	28.27	28.3	18583.0
2012-01-19 08:30:00	MSFT	Stock	28.3	28.36	28.25	28.26	42252.0
2012-01-19 09:00:00	MSFT	Stock	28.29	28.37	28.12	28.14	142611.0
2012-01-19 09:30:00	MSFT	Stock	28.15	28.2	28.05	28.159	8627776.0
2012-01-19 10:00:00	MSFT	Stock	28.15	28.28	28.14	28.175	6252796.0
2012-01-19 10:30:00	MSFT	Stock	28.175	28.32	28.17	28.315	3442340.0
2012-01-19 11:00:00	MSFT	Stock	28.315	28.435	28.31	28.399	3693635.0
2012-01-19 11:30:00	MSFT	Stock	28.39	28.4	28.3	28.323	4435896.0
2012-01-19 12:00:00	MSFT	Stock	28.33	28.34	28.22	28.25	4661564.0
2012-01-19 12:30:00	MSFT	Stock	28.245	28.26	28.19	28.24	2864379.0
2012-01-19 13:00:00	MSFT	Stock	28.231	28.26	28.16	28.24	3289524.0
2012-01-19 13:30:00	MSFT	Stock	28.24	28.24	28.12	28.13	4169452.0
2012-01-19 14:00:00	MSFT	Stock	28.125	28.2	28.115	28.17	3742946.0
2012-01-19 14:30:00	MSFT	Stock	28.175	28.2	28.11	28.135	4129000.0
2012-01-19 15:00:00	MSFT	Stock	28.135	28.175	28.12	28.12	5599488.0
2012-01-19 15:30:00	MSFT	Stock	28.125	28.17	28.03	28.13	10818737.0
2012-01-19 16:00:00	MSFT	Stock	28.129	29.0	27.84	28.78	5778058.0
2012-01-19 16:30:00	MSFT	Stock	28.78	28.89	28.12	28.76	539300.0
2012-01-19 17:00:00	MSFT	Stock	28.76	28.77	28.61	28.66	115348.0

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

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