PREVIEW / stock_30min / 2009-11-23

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-11-23.parquet
  size:    1.4 MB
  rows:    73,149
  symbols: 3,416

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
2009-11-23 04:00:00	AAPL	Stock	7.1732	7.1732	7.1732	7.1732	5600.0
2009-11-23 07:00:00	AAPL	Stock	7.2071	7.2321	7.2071	7.2196	102200.0
2009-11-23 07:30:00	AAPL	Stock	7.215	7.2311	7.2079	7.2271	137284.0
2009-11-23 08:00:00	AAPL	Stock	7.2146	7.2439	7.14	7.23	1353296.0
2009-11-23 08:30:00	AAPL	Stock	7.2318	7.2336	7.2268	7.23	565740.0
2009-11-23 09:00:00	AAPL	Stock	7.2286	7.25	7.2286	7.2486	2951060.0
2009-11-23 09:30:00	AAPL	Stock	7.2482	7.3214	7.2482	7.3157	76911884.0
2009-11-23 10:00:00	AAPL	Stock	7.3179	7.3289	7.3046	7.3198	58289896.0
2009-11-23 10:30:00	AAPL	Stock	7.3197	7.3371	7.3046	7.3079	39120172.0
2009-11-23 11:00:00	AAPL	Stock	7.3076	7.3189	7.3075	7.3111	14750288.0
2009-11-23 11:30:00	AAPL	Stock	7.3111	7.3196	7.3045	7.3054	17509800.0
2009-11-23 12:00:00	AAPL	Stock	7.3057	7.3214	7.3046	7.3146	14667324.0
2009-11-23 12:30:00	AAPL	Stock	7.3154	7.3214	7.3	7.3204	20519688.0
2009-11-23 13:00:00	AAPL	Stock	7.3204	7.3214	7.3014	7.3125	14351484.0
2009-11-23 13:30:00	AAPL	Stock	7.3121	7.3182	7.2971	7.3016	15123220.0
2009-11-23 14:00:00	AAPL	Stock	7.3025	7.3071	7.2857	7.3061	20327440.0
2009-11-23 14:30:00	AAPL	Stock	7.3068	7.3161	7.3036	7.3082	10892252.0
2009-11-23 15:00:00	AAPL	Stock	7.3079	7.3286	7.3054	7.3246	25462164.0
2009-11-23 15:30:00	AAPL	Stock	7.3243	7.3571	7.3071	7.3525	64837836.0
2009-11-23 16:00:00	AAPL	Stock	7.3521	7.3543	7.3111	7.3439	7093268.0
2009-11-23 16:30:00	AAPL	Stock	7.3431	7.3471	7.3431	7.3432	291200.0
2009-11-23 17:00:00	AAPL	Stock	7.3464	7.3471	7.3432	7.3471	60340.0
2009-11-23 17:30:00	AAPL	Stock	7.3429	7.3454	7.3414	7.3454	25200.0
2009-11-23 18:00:00	AAPL	Stock	7.3414	7.3529	7.3393	7.3482	1171128.0
2009-11-23 18:30:00	AAPL	Stock	7.3457	7.3471	7.3393	7.3393	21700.0
2009-11-23 19:00:00	AAPL	Stock	7.3393	7.3393	7.3393	7.3393	5600.0
2009-11-23 19:30:00	AAPL	Stock	7.3396	7.3457	7.3364	7.3368	110656.0
2009-11-23 04:00:00	MSFT	Stock	29.7	29.7	29.7	29.7	100.0
2009-11-23 04:30:00	MSFT	Stock	29.84	29.84	29.84	29.84	400.0
2009-11-23 06:30:00	MSFT	Stock	29.76	29.76	29.76	29.76	145.0
2009-11-23 07:00:00	MSFT	Stock	29.76	29.84	29.76	29.84	225.0
2009-11-23 07:30:00	MSFT	Stock	29.84	29.89	29.84	29.89	4600.0
2009-11-23 08:00:00	MSFT	Stock	29.82	29.89	29.62	29.87	7453.0
2009-11-23 08:30:00	MSFT	Stock	29.85	29.94	29.85	29.93	9175.0
2009-11-23 09:00:00	MSFT	Stock	29.93	29.97	29.62	29.85	1071416.0
2009-11-23 09:30:00	MSFT	Stock	29.88	29.99	29.7	29.97	5952560.0
2009-11-23 10:00:00	MSFT	Stock	29.98	30.0	29.91	29.99	5305230.0
2009-11-23 10:30:00	MSFT	Stock	29.99	30.01	29.9	29.94	3871303.0
2009-11-23 11:00:00	MSFT	Stock	29.94	29.97	29.9	29.902	3713853.0
2009-11-23 11:30:00	MSFT	Stock	29.902	29.94	29.87	29.88	2794504.0
2009-11-23 12:00:00	MSFT	Stock	29.871	29.94	29.75	29.905	1657788.0
2009-11-23 12:30:00	MSFT	Stock	29.9	29.96	29.87	29.91	1635480.0
2009-11-23 13:00:00	MSFT	Stock	29.912	29.98	29.88	29.952	1874498.0
2009-11-23 13:30:00	MSFT	Stock	29.957	29.98	29.93	29.942	1122382.0
2009-11-23 14:00:00	MSFT	Stock	29.94	29.96	29.92	29.95	1848249.0
2009-11-23 14:30:00	MSFT	Stock	29.96	29.96	29.89	29.9	1543426.0
2009-11-23 15:00:00	MSFT	Stock	29.905	29.95	29.895	29.9	2075456.0
2009-11-23 15:30:00	MSFT	Stock	29.9	29.94	29.86	29.94	4865074.0
2009-11-23 16:00:00	MSFT	Stock	29.93	29.95	29.851	29.91	1665739.0
2009-11-23 16:30:00	MSFT	Stock	29.9	29.94	29.9	29.94	2100.0

> showing 50 of 73,149 rows — these rows as CSV

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