PREVIEW / stock_30min / 2008-11-24

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-24.parquet
  size:    1.2 MB
  rows:    71,520
  symbols: 3,377

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-11-24 06:30:00	AAPL	Stock	2.9679	2.9679	2.9679	2.9679	2800.0
2008-11-24 07:00:00	AAPL	Stock	3.0	3.0357	3.0	3.0089	339164.0
2008-11-24 07:30:00	AAPL	Stock	3.0	3.0089	2.9954	3.0071	93660.0
2008-11-24 08:00:00	AAPL	Stock	3.0071	3.0157	2.9911	3.0121	1133104.0
2008-11-24 08:30:00	AAPL	Stock	3.01	3.0125	2.9929	3.0089	1100484.0
2008-11-24 09:00:00	AAPL	Stock	3.0082	3.0432	3.0071	3.0407	2708048.0
2008-11-24 09:30:00	AAPL	Stock	3.0432	3.0982	3.03	3.0618	158196332.0
2008-11-24 10:00:00	AAPL	Stock	3.0618	3.1764	3.0589	3.1682	142092860.0
2008-11-24 10:30:00	AAPL	Stock	3.1693	3.2054	3.1614	3.2039	130093908.0
2008-11-24 11:00:00	AAPL	Stock	3.2039	3.2411	3.1743	3.2296	98650916.0
2008-11-24 11:30:00	AAPL	Stock	3.2321	3.2407	3.1907	3.222	84510356.0
2008-11-24 12:00:00	AAPL	Stock	3.2218	3.2457	3.175	3.1793	86536968.0
2008-11-24 12:30:00	AAPL	Stock	3.1793	3.2179	3.1754	3.2071	67195352.0
2008-11-24 13:00:00	AAPL	Stock	3.2079	3.2179	3.1839	3.2118	51604000.0
2008-11-24 13:30:00	AAPL	Stock	3.2118	3.2289	3.1957	3.2271	52499104.0
2008-11-24 14:00:00	AAPL	Stock	3.2268	3.2568	3.1964	3.2489	84328664.0
2008-11-24 14:30:00	AAPL	Stock	3.2482	3.29	3.2468	3.2789	106900444.0
2008-11-24 15:00:00	AAPL	Stock	3.2782	3.3536	3.2668	3.3518	106862560.0
2008-11-24 15:30:00	AAPL	Stock	3.3525	3.3854	3.2464	3.3136	209727952.0
2008-11-24 16:00:00	AAPL	Stock	3.3118	3.3271	3.2102	3.3018	36059240.0
2008-11-24 16:30:00	AAPL	Stock	3.3	3.3196	3.2127	3.3007	10341352.0
2008-11-24 17:00:00	AAPL	Stock	3.2993	3.3143	3.2813	3.3036	466508.0
2008-11-24 17:30:00	AAPL	Stock	3.3036	3.3114	3.0393	3.3018	190064.0
2008-11-24 18:00:00	AAPL	Stock	3.3018	3.3107	3.3	3.3075	100744.0
2008-11-24 18:30:00	AAPL	Stock	3.3079	3.3107	3.3039	3.3075	62580.0
2008-11-24 19:00:00	AAPL	Stock	3.3043	3.3071	3.3036	3.3054	48076.0
2008-11-24 19:30:00	AAPL	Stock	3.3071	3.3157	3.3071	3.3143	292656.0
2008-11-24 04:30:00	MSFT	Stock	19.75	19.75	19.75	19.75	100.0
2008-11-24 05:00:00	MSFT	Stock	19.89	19.89	19.89	19.89	449.0
2008-11-24 07:00:00	MSFT	Stock	19.89	19.98	19.89	19.98	2150.0
2008-11-24 07:30:00	MSFT	Stock	19.95	19.99	19.94	19.96	7400.0
2008-11-24 08:00:00	MSFT	Stock	19.95	19.99	19.7	19.94	22128.0
2008-11-24 08:30:00	MSFT	Stock	19.91	19.94	19.84	19.9	22696.0
2008-11-24 09:00:00	MSFT	Stock	19.9	19.92	19.84	19.9	33259.0
2008-11-24 09:30:00	MSFT	Stock	19.89	20.47	19.87	20.4	9690289.0
2008-11-24 10:00:00	MSFT	Stock	20.41	20.94	20.39	20.85	12934225.0
2008-11-24 10:30:00	MSFT	Stock	20.85	20.94	20.47	20.7	7776490.0
2008-11-24 11:00:00	MSFT	Stock	20.7	20.72	20.48	20.532	7526627.0
2008-11-24 11:30:00	MSFT	Stock	20.54	20.65	20.4	20.53	9083125.0
2008-11-24 12:00:00	MSFT	Stock	20.54	20.58	20.15	20.16	6623671.0
2008-11-24 12:30:00	MSFT	Stock	20.16	20.42	20.14	20.38	5355742.0
2008-11-24 13:00:00	MSFT	Stock	20.39	20.45	20.22	20.29	4420653.0
2008-11-24 13:30:00	MSFT	Stock	20.31	20.472	20.24	20.45	4663247.0
2008-11-24 14:00:00	MSFT	Stock	20.455	20.47	20.27	20.41	6393567.0
2008-11-24 14:30:00	MSFT	Stock	20.41	20.5	20.27	20.43	5728641.0
2008-11-24 15:00:00	MSFT	Stock	20.44	20.81	20.36	20.74	9780338.0
2008-11-24 15:30:00	MSFT	Stock	20.74	20.912	20.26	20.69	20424047.0
2008-11-24 16:00:00	MSFT	Stock	20.69	20.77	20.442	20.654	10445039.0
2008-11-24 16:30:00	MSFT	Stock	20.57	20.69	20.43	20.55	2196457.0
2008-11-24 17:00:00	MSFT	Stock	20.55	20.57	20.52	20.52	3089.0

> showing 50 of 71,520 rows — these rows as CSV

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