PREVIEW / stock_30min / 2008-09-12

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-09-12.parquet
  size:    1.2 MB
  rows:    69,336
  symbols: 3,313

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-09-12 07:00:00	AAPL	Stock	5.4711	5.4711	5.4182	5.4182	5600.0
2008-09-12 07:30:00	AAPL	Stock	5.4464	5.4464	5.4289	5.4289	5600.0
2008-09-12 08:00:00	AAPL	Stock	5.4289	5.455	5.4289	5.4425	516376.0
2008-09-12 08:30:00	AAPL	Stock	5.4389	5.4389	5.3946	5.3982	1001476.0
2008-09-12 09:00:00	AAPL	Stock	5.3986	5.4036	5.3825	5.3864	1195740.0
2008-09-12 09:30:00	AAPL	Stock	5.3861	5.3896	5.29	5.2979	105869484.0
2008-09-12 10:00:00	AAPL	Stock	5.2982	5.3193	5.2679	5.2871	82663168.0
2008-09-12 10:30:00	AAPL	Stock	5.2882	5.2932	5.2321	5.2561	85759632.0
2008-09-12 11:00:00	AAPL	Stock	5.2564	5.3643	5.255	5.3382	97165964.0
2008-09-12 11:30:00	AAPL	Stock	5.3386	5.34	5.2918	5.3118	47291104.0
2008-09-12 12:00:00	AAPL	Stock	5.3125	5.325	5.2929	5.2964	32710104.0
2008-09-12 12:30:00	AAPL	Stock	5.2954	5.3096	5.2536	5.2636	39731244.0
2008-09-12 13:00:00	AAPL	Stock	5.2636	5.3029	5.245	5.2921	37935100.0
2008-09-12 13:30:00	AAPL	Stock	5.2918	5.3082	5.2689	5.2993	30904160.0
2008-09-12 14:00:00	AAPL	Stock	5.2996	5.3211	5.2639	5.3025	40617780.0
2008-09-12 14:30:00	AAPL	Stock	5.3025	5.3761	5.2954	5.3654	59032176.0
2008-09-12 15:00:00	AAPL	Stock	5.3651	5.3675	5.3046	5.3168	53386564.0
2008-09-12 15:30:00	AAPL	Stock	5.3168	5.3304	5.2929	5.3186	58898532.0
2008-09-12 16:00:00	AAPL	Stock	5.3186	5.3329	5.3018	5.3304	7860356.0
2008-09-12 16:30:00	AAPL	Stock	5.3304	5.3304	5.3193	5.3268	660100.0
2008-09-12 17:00:00	AAPL	Stock	5.3214	5.325	5.3193	5.3196	940520.0
2008-09-12 17:30:00	AAPL	Stock	5.3214	5.3214	5.3125	5.3125	146160.0
2008-09-12 18:00:00	AAPL	Stock	5.3171	5.3179	5.3143	5.3143	99708.0
2008-09-12 18:30:00	AAPL	Stock	5.3164	5.3204	5.3143	5.3143	70420.0
2008-09-12 19:00:00	AAPL	Stock	5.3143	5.3143	5.3136	5.3139	79912.0
2008-09-12 19:30:00	AAPL	Stock	5.3139	5.3179	5.3139	5.3179	76524.0
2008-09-12 20:00:00	AAPL	Stock	5.3536	5.3536	5.3536	5.3536	2800.0
2008-09-12 07:00:00	MSFT	Stock	27.34	27.34	27.34	27.34	200.0
2008-09-12 08:00:00	MSFT	Stock	27.14	27.14	27.13	27.13	400.0
2008-09-12 08:30:00	MSFT	Stock	27.13	27.2	27.13	27.2	1950.0
2008-09-12 09:00:00	MSFT	Stock	27.18	27.25	27.05	27.2	19518.0
2008-09-12 09:30:00	MSFT	Stock	27.2	27.2	26.94	27.04	5667255.0
2008-09-12 10:00:00	MSFT	Stock	27.04	27.278	27.02	27.18	6743774.0
2008-09-12 10:30:00	MSFT	Stock	27.18	27.38	27.15	27.38	5415203.0
2008-09-12 11:00:00	MSFT	Stock	27.39	27.62	27.35	27.615	8811877.0
2008-09-12 11:30:00	MSFT	Stock	27.62	27.62	27.46	27.549	4284568.0
2008-09-12 12:00:00	MSFT	Stock	27.54	27.66	27.54	27.612	4147138.0
2008-09-12 12:30:00	MSFT	Stock	27.61	27.64	27.44	27.46	5549760.0
2008-09-12 13:00:00	MSFT	Stock	27.46	27.5	27.37	27.44	4347165.0
2008-09-12 13:30:00	MSFT	Stock	27.45	27.53	27.38	27.523	3397517.0
2008-09-12 14:00:00	MSFT	Stock	27.52	27.59	27.45	27.51	3650821.0
2008-09-12 14:30:00	MSFT	Stock	27.51	27.72	27.45	27.7	5323842.0
2008-09-12 15:00:00	MSFT	Stock	27.7	27.74	27.58	27.62	5512931.0
2008-09-12 15:30:00	MSFT	Stock	27.62	27.68	27.49	27.65	7360634.0
2008-09-12 16:00:00	MSFT	Stock	27.65	27.68	27.442	27.62	2534903.0
2008-09-12 16:30:00	MSFT	Stock	27.62	27.62	27.5	27.5	98203.0
2008-09-12 17:00:00	MSFT	Stock	27.63	27.63	27.6	27.6	200.0
2008-09-12 18:30:00	MSFT	Stock	27.6	27.65	27.6	27.62	2100.0
2008-09-12 19:00:00	MSFT	Stock	27.6	27.6	27.6	27.6	150.0
2008-09-12 19:30:00	MSFT	Stock	27.6	27.6	27.6	27.6	300.0

> showing 50 of 69,336 rows — these rows as CSV

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