PREVIEW / stock_30min / 2010-06-16

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-06-16.parquet
  size:    1.3 MB
  rows:    72,090
  symbols: 3,459

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
2010-06-16 05:00:00	AAPL	Stock	9.2321	9.2321	9.2321	9.2321	5600.0
2010-06-16 05:30:00	AAPL	Stock	9.2196	9.2196	9.2196	9.2196	3500.0
2010-06-16 06:00:00	AAPL	Stock	9.22	9.2239	9.2196	9.2196	26600.0
2010-06-16 07:00:00	AAPL	Stock	9.2554	9.2554	9.2389	9.2554	25200.0
2010-06-16 07:30:00	AAPL	Stock	9.2554	9.2821	9.2457	9.2518	345240.0
2010-06-16 08:00:00	AAPL	Stock	9.2536	9.2582	9.2214	9.2221	1214220.0
2010-06-16 08:30:00	AAPL	Stock	9.2225	9.2721	9.2071	9.2679	2722776.0
2010-06-16 09:00:00	AAPL	Stock	9.2643	9.3489	9.26	9.325	5735744.0
2010-06-16 09:30:00	AAPL	Stock	9.325	9.4239	9.3082	9.4104	117694752.0
2010-06-16 10:00:00	AAPL	Stock	9.4104	9.4136	9.3764	9.3893	48797476.0
2010-06-16 10:30:00	AAPL	Stock	9.3871	9.4271	9.3714	9.4271	58682148.0
2010-06-16 11:00:00	AAPL	Stock	9.4271	9.4514	9.4082	9.445	55127604.0
2010-06-16 11:30:00	AAPL	Stock	9.4457	9.4954	9.4389	9.4918	78355620.0
2010-06-16 12:00:00	AAPL	Stock	9.4918	9.5179	9.4879	9.5022	51248904.0
2010-06-16 12:30:00	AAPL	Stock	9.5007	9.5086	9.4654	9.4893	38889172.0
2010-06-16 13:00:00	AAPL	Stock	9.4896	9.51	9.4732	9.5082	27189904.0
2010-06-16 13:30:00	AAPL	Stock	9.5082	9.5175	9.4914	9.515	31510500.0
2010-06-16 14:00:00	AAPL	Stock	9.515	9.5343	9.5057	9.5318	35650188.0
2010-06-16 14:30:00	AAPL	Stock	9.5307	9.5625	9.5296	9.5543	54879720.0
2010-06-16 15:00:00	AAPL	Stock	9.5536	9.5554	9.4968	9.5121	71958208.0
2010-06-16 15:30:00	AAPL	Stock	9.5118	9.5457	9.4946	9.5457	83602456.0
2010-06-16 16:00:00	AAPL	Stock	9.5457	9.5625	9.3124	9.5529	7825412.0
2010-06-16 16:30:00	AAPL	Stock	9.5507	9.5532	9.4677	9.5532	813820.0
2010-06-16 17:00:00	AAPL	Stock	9.5525	9.5532	9.5446	9.5518	151816.0
2010-06-16 17:30:00	AAPL	Stock	9.55	9.5554	9.55	9.5536	207900.0
2010-06-16 18:00:00	AAPL	Stock	9.5536	9.5536	9.5379	9.5379	563332.0
2010-06-16 18:30:00	AAPL	Stock	9.5396	9.55	9.5396	9.55	145600.0
2010-06-16 19:00:00	AAPL	Stock	9.55	9.5518	9.5446	9.5507	97524.0
2010-06-16 19:30:00	AAPL	Stock	9.55	9.5554	9.5486	9.5536	345660.0
2010-06-16 07:00:00	MSFT	Stock	26.47	26.47	26.46	26.46	1100.0
2010-06-16 07:30:00	MSFT	Stock	26.47	26.47	26.43	26.43	10500.0
2010-06-16 08:00:00	MSFT	Stock	26.45	26.45	26.34	26.35	19452.0
2010-06-16 08:30:00	MSFT	Stock	26.35	26.45	26.33	26.41	21842.0
2010-06-16 09:00:00	MSFT	Stock	26.42	26.47	26.4	26.46	11089.0
2010-06-16 09:30:00	MSFT	Stock	26.46	26.58	26.31	26.378	4717191.0
2010-06-16 10:00:00	MSFT	Stock	26.375	26.41	26.3	26.39	5024313.0
2010-06-16 10:30:00	MSFT	Stock	26.38	26.44	26.36	26.42	3024626.0
2010-06-16 11:00:00	MSFT	Stock	26.421	26.55	26.4	26.51	3659509.0
2010-06-16 11:30:00	MSFT	Stock	26.51	26.52	26.38	26.401	2051643.0
2010-06-16 12:00:00	MSFT	Stock	26.41	26.54	26.4	26.52	1529383.0
2010-06-16 12:30:00	MSFT	Stock	26.51	26.52	26.41	26.46	1278705.0
2010-06-16 13:00:00	MSFT	Stock	26.47	26.5	26.42	26.49	1665744.0
2010-06-16 13:30:00	MSFT	Stock	26.489	26.5	26.431	26.5	1728689.0
2010-06-16 14:00:00	MSFT	Stock	26.5	26.535	26.46	26.491	1686038.0
2010-06-16 14:30:00	MSFT	Stock	26.495	26.55	26.41	26.44	3233677.0
2010-06-16 15:00:00	MSFT	Stock	26.44	26.44	26.23	26.265	4061981.0
2010-06-16 15:30:00	MSFT	Stock	26.265	26.36	26.25	26.33	7698578.0
2010-06-16 16:00:00	MSFT	Stock	26.33	26.407	26.28	26.32	5927393.0
2010-06-16 16:30:00	MSFT	Stock	26.4	26.4	26.3	26.308	56530.0
2010-06-16 17:00:00	MSFT	Stock	26.499	26.499	26.31	26.31	452635.0

> showing 50 of 72,090 rows — these rows as CSV

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