PREVIEW / stock_30min / 2008-01-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-01-07.parquet
  size:    1.2 MB
  rows:    70,972
  symbols: 3,246

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
2008-01-07 04:00:00	AAPL	Stock	6.4643	6.4643	6.4643	6.4643	11312.0
2008-01-07 05:30:00	AAPL	Stock	6.4911	6.4911	6.4911	6.4911	11200.0
2008-01-07 06:00:00	AAPL	Stock	6.4821	6.4821	6.4821	6.4821	24220.0
2008-01-07 06:30:00	AAPL	Stock	6.5179	6.5268	6.5179	6.5268	81200.0
2008-01-07 07:00:00	AAPL	Stock	6.5268	6.5357	6.5007	6.5136	762748.0
2008-01-07 07:30:00	AAPL	Stock	6.5136	6.525	6.5011	6.5132	1316672.0
2008-01-07 08:00:00	AAPL	Stock	6.5107	6.5207	6.4304	6.47	4161976.0
2008-01-07 08:30:00	AAPL	Stock	6.4714	6.4893	6.4304	6.48	8422148.0
2008-01-07 09:00:00	AAPL	Stock	6.4746	6.4821	6.4418	6.4736	6164004.0
2008-01-07 09:30:00	AAPL	Stock	6.4714	6.5571	6.4361	6.5229	217125916.0
2008-01-07 10:00:00	AAPL	Stock	6.5243	6.5471	6.2321	6.2429	250713540.0
2008-01-07 10:30:00	AAPL	Stock	6.2425	6.2679	6.0796	6.1804	289465400.0
2008-01-07 11:00:00	AAPL	Stock	6.1793	6.3471	6.175	6.2868	181605116.0
2008-01-07 11:30:00	AAPL	Stock	6.2861	6.4721	6.2764	6.3804	172913384.0
2008-01-07 12:00:00	AAPL	Stock	6.3796	6.4214	6.2964	6.3782	114031988.0
2008-01-07 12:30:00	AAPL	Stock	6.3789	6.4357	6.3718	6.4154	91702940.0
2008-01-07 13:00:00	AAPL	Stock	6.4154	6.4282	6.3486	6.3611	67068960.0
2008-01-07 13:30:00	AAPL	Stock	6.3604	6.3796	6.2971	6.3271	93923088.0
2008-01-07 14:00:00	AAPL	Stock	6.3271	6.3436	6.2043	6.2371	127941968.0
2008-01-07 14:30:00	AAPL	Stock	6.2371	6.3411	6.2186	6.2736	112138852.0
2008-01-07 15:00:00	AAPL	Stock	6.2725	6.31	6.2343	6.2407	108011596.0
2008-01-07 15:30:00	AAPL	Stock	6.2421	6.3861	6.1429	6.3421	210810152.0
2008-01-07 16:00:00	AAPL	Stock	6.3481	6.3884	6.3007	6.3436	11861528.0
2008-01-07 16:30:00	AAPL	Stock	6.3475	6.3642	6.3171	6.3571	596652.0
2008-01-07 17:00:00	AAPL	Stock	6.355	6.3561	6.3393	6.3464	467264.0
2008-01-07 17:30:00	AAPL	Stock	6.3404	6.5188	6.3285	6.3464	236404.0
2008-01-07 18:00:00	AAPL	Stock	6.3464	6.3464	6.3393	6.3464	286356.0
2008-01-07 18:30:00	AAPL	Stock	6.3461	6.3468	6.34	6.3457	242088.0
2008-01-07 19:00:00	AAPL	Stock	6.3446	6.3514	6.34	6.34	94640.0
2008-01-07 19:30:00	AAPL	Stock	6.3432	6.3446	6.3357	6.3357	379652.0
2008-01-07 07:30:00	MSFT	Stock	34.45	34.45	34.45	34.45	100.0
2008-01-07 08:00:00	MSFT	Stock	34.46	34.97	34.38	34.77	199388.0
2008-01-07 08:30:00	MSFT	Stock	34.77	34.85	34.65	34.65	6248.0
2008-01-07 09:00:00	MSFT	Stock	34.68	34.7	34.45	34.45	102972.0
2008-01-07 09:30:00	MSFT	Stock	34.51	34.8	34.43	34.66	7567577.0
2008-01-07 10:00:00	MSFT	Stock	34.66	34.67	34.33	34.36	8607294.0
2008-01-07 10:30:00	MSFT	Stock	34.37	34.59	34.25	34.48	7974978.0
2008-01-07 11:00:00	MSFT	Stock	34.49	34.72	34.42	34.61	7205064.0
2008-01-07 11:30:00	MSFT	Stock	34.61	34.74	34.55	34.65	4611468.0
2008-01-07 12:00:00	MSFT	Stock	34.64	34.74	34.49	34.698	4075442.0
2008-01-07 12:30:00	MSFT	Stock	34.7	34.76	34.59	34.68	4259340.0
2008-01-07 13:00:00	MSFT	Stock	34.68	34.77	34.6	34.64	3346094.0
2008-01-07 13:30:00	MSFT	Stock	34.65	34.69	34.44	34.46	3827337.0
2008-01-07 14:00:00	MSFT	Stock	34.46	34.54	34.33	34.41	5081729.0
2008-01-07 14:30:00	MSFT	Stock	34.41	34.59	34.31	34.44	4835390.0
2008-01-07 15:00:00	MSFT	Stock	34.44	34.52	34.3	34.41	6626298.0
2008-01-07 15:30:00	MSFT	Stock	34.42	34.78	34.26	34.65	10154988.0
2008-01-07 16:00:00	MSFT	Stock	34.62	34.7	34.505	34.64	1695062.0
2008-01-07 16:30:00	MSFT	Stock	34.528	34.7	34.528	34.65	55130.0
2008-01-07 17:00:00	MSFT	Stock	34.68	34.73	34.63	34.63	3910.0

> showing 50 of 70,972 rows — these rows as CSV

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