PREVIEW / stock_30min / 2009-04-21

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-21.parquet
  size:    1.3 MB
  rows:    70,982
  symbols: 3,307

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-04-21 07:30:00	AAPL	Stock	4.3036	4.3036	4.3036	4.3036	2800.0
2009-04-21 08:00:00	AAPL	Stock	4.3025	4.3061	4.2786	4.2786	207340.0
2009-04-21 08:30:00	AAPL	Stock	4.28	4.2821	4.2589	4.2607	636972.0
2009-04-21 09:00:00	AAPL	Stock	4.2618	4.2629	4.2457	4.2489	1257312.0
2009-04-21 09:30:00	AAPL	Stock	4.2461	4.3436	4.2357	4.335	72849504.0
2009-04-21 10:00:00	AAPL	Stock	4.335	4.3364	4.2929	4.2936	36373064.0
2009-04-21 10:30:00	AAPL	Stock	4.2934	4.3321	4.2832	4.3311	27634936.0
2009-04-21 11:00:00	AAPL	Stock	4.3311	4.3621	4.3214	4.35	34454672.0
2009-04-21 11:30:00	AAPL	Stock	4.3496	4.3546	4.3282	4.347	28719180.0
2009-04-21 12:00:00	AAPL	Stock	4.3471	4.3564	4.3396	4.3493	18033568.0
2009-04-21 12:30:00	AAPL	Stock	4.3489	4.3596	4.3418	4.3486	23678172.0
2009-04-21 13:00:00	AAPL	Stock	4.3486	4.355	4.3336	4.3432	20703452.0
2009-04-21 13:30:00	AAPL	Stock	4.3432	4.3565	4.3343	4.3489	22611820.0
2009-04-21 14:00:00	AAPL	Stock	4.3493	4.3536	4.3161	4.3221	37858296.0
2009-04-21 14:30:00	AAPL	Stock	4.3225	4.3443	4.3161	4.3193	32504332.0
2009-04-21 15:00:00	AAPL	Stock	4.3211	4.3611	4.3175	4.3457	39254544.0
2009-04-21 15:30:00	AAPL	Stock	4.3461	4.3593	4.3332	4.3489	56139888.0
2009-04-21 16:00:00	AAPL	Stock	4.3482	4.3586	4.3314	4.3557	6999104.0
2009-04-21 16:30:00	AAPL	Stock	4.3532	4.3554	4.3464	4.3518	231308.0
2009-04-21 17:00:00	AAPL	Stock	4.3536	4.3536	4.3289	4.3332	397656.0
2009-04-21 17:30:00	AAPL	Stock	4.3332	4.3382	4.3289	4.3382	278740.0
2009-04-21 18:00:00	AAPL	Stock	4.3339	4.3486	4.3321	4.3446	434028.0
2009-04-21 18:30:00	AAPL	Stock	4.3457	4.3554	4.3454	4.35	537292.0
2009-04-21 19:00:00	AAPL	Stock	4.35	4.3554	4.35	4.35	140784.0
2009-04-21 19:30:00	AAPL	Stock	4.3536	4.3554	4.3496	4.3504	108724.0
2009-04-21 20:00:00	AAPL	Stock	4.3036	4.3036	4.3036	4.3036	14000.0
2009-04-21 08:00:00	MSFT	Stock	18.63	18.63	18.6	18.61	29551.0
2009-04-21 08:30:00	MSFT	Stock	18.7	18.7	18.62	18.64	10936.0
2009-04-21 09:00:00	MSFT	Stock	18.64	18.68	18.57	18.58	305885.0
2009-04-21 09:30:00	MSFT	Stock	18.59	19.08	18.57	18.94	9114530.0
2009-04-21 10:00:00	MSFT	Stock	18.93	18.94	18.73	18.88	6318899.0
2009-04-21 10:30:00	MSFT	Stock	18.87	18.88	18.75	18.85	4555826.0
2009-04-21 11:00:00	MSFT	Stock	18.86	18.97	18.81	18.93	4560537.0
2009-04-21 11:30:00	MSFT	Stock	18.94	18.98	18.88	18.98	3613442.0
2009-04-21 12:00:00	MSFT	Stock	18.98	18.98	18.79	18.81	3464600.0
2009-04-21 12:30:00	MSFT	Stock	18.8	18.89	18.72	18.8	3371606.0
2009-04-21 13:00:00	MSFT	Stock	18.79	18.82	18.72	18.77	2501194.0
2009-04-21 13:30:00	MSFT	Stock	18.768	18.78	18.7	18.78	2516978.0
2009-04-21 14:00:00	MSFT	Stock	18.77	18.835	18.73	18.82	2124370.0
2009-04-21 14:30:00	MSFT	Stock	18.812	18.88	18.78	18.8	3364873.0
2009-04-21 15:00:00	MSFT	Stock	18.81	18.9	18.8	18.85	4370674.0
2009-04-21 15:30:00	MSFT	Stock	18.86	18.98	18.835	18.97	7120387.0
2009-04-21 16:00:00	MSFT	Stock	18.96	18.972	18.81	18.81	1911286.0
2009-04-21 16:30:00	MSFT	Stock	18.876	18.97	18.81	18.87	54260.0
2009-04-21 17:00:00	MSFT	Stock	18.87	18.94	18.87	18.9	2461.0
2009-04-21 17:30:00	MSFT	Stock	18.9	18.91	18.9	18.91	1100.0
2009-04-21 18:00:00	MSFT	Stock	18.97	18.97	18.9	18.9	37567.0
2009-04-21 18:30:00	MSFT	Stock	18.93	18.93	18.93	18.93	1275.0
2009-04-21 19:00:00	MSFT	Stock	18.9	18.93	18.9	18.9	800.0
2009-04-21 19:30:00	MSFT	Stock	18.9	18.9	18.89	18.89	1700.0

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

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