PREVIEW / stock_30min / 2009-04-20

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-20.parquet
  size:    1.3 MB
  rows:    71,352
  symbols: 3,310

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-20 04:30:00	AAPL	Stock	4.3882	4.3882	4.3882	4.3882	2800.0
2009-04-20 05:30:00	AAPL	Stock	4.3214	4.3214	4.3214	4.3214	2800.0
2009-04-20 06:00:00	AAPL	Stock	4.3564	4.3564	4.3564	4.3564	8400.0
2009-04-20 06:30:00	AAPL	Stock	4.3464	4.3464	4.3464	4.3464	2800.0
2009-04-20 07:00:00	AAPL	Stock	4.3464	4.365	4.3357	4.3643	61460.0
2009-04-20 07:30:00	AAPL	Stock	4.3704	4.3821	4.3686	4.3821	159600.0
2009-04-20 08:00:00	AAPL	Stock	4.3832	4.3946	4.3571	4.3607	927612.0
2009-04-20 08:30:00	AAPL	Stock	4.3607	4.3814	4.3604	4.3732	425320.0
2009-04-20 09:00:00	AAPL	Stock	4.3696	4.3696	4.3464	4.3525	1729896.0
2009-04-20 09:30:00	AAPL	Stock	4.35	4.3925	4.3411	4.3518	69271804.0
2009-04-20 10:00:00	AAPL	Stock	4.3521	4.3707	4.3175	4.3207	43238104.0
2009-04-20 10:30:00	AAPL	Stock	4.3211	4.3671	4.2893	4.3004	36074724.0
2009-04-20 11:00:00	AAPL	Stock	4.3007	4.3139	4.2893	4.3054	25434332.0
2009-04-20 11:30:00	AAPL	Stock	4.3057	4.3129	4.2918	4.2972	19112576.0
2009-04-20 12:00:00	AAPL	Stock	4.2986	4.3064	4.29	4.3	16111144.0
2009-04-20 12:30:00	AAPL	Stock	4.3007	4.3107	4.2886	4.3082	18370520.0
2009-04-20 13:00:00	AAPL	Stock	4.3079	4.3082	4.2868	4.2943	19927740.0
2009-04-20 13:30:00	AAPL	Stock	4.2936	4.3054	4.2789	4.3	30250948.0
2009-04-20 14:00:00	AAPL	Stock	4.2986	4.3	4.2789	4.2879	22667848.0
2009-04-20 14:30:00	AAPL	Stock	4.2882	4.2896	4.2571	4.2645	28601804.0
2009-04-20 15:00:00	AAPL	Stock	4.265	4.275	4.2557	4.2671	28562660.0
2009-04-20 15:30:00	AAPL	Stock	4.2671	4.3339	4.2668	4.3029	78498896.0
2009-04-20 16:00:00	AAPL	Stock	4.3029	4.3257	4.2857	4.2971	19422480.0
2009-04-20 16:30:00	AAPL	Stock	4.3	4.3114	4.2729	4.3014	573580.0
2009-04-20 17:00:00	AAPL	Stock	4.3	4.3086	4.3	4.3086	123620.0
2009-04-20 17:30:00	AAPL	Stock	4.3086	4.3125	4.3036	4.3125	72800.0
2009-04-20 18:00:00	AAPL	Stock	4.3093	4.3143	4.3093	4.3121	100800.0
2009-04-20 18:30:00	AAPL	Stock	4.3121	4.3121	4.3071	4.3071	25900.0
2009-04-20 19:00:00	AAPL	Stock	4.3043	4.3043	4.3036	4.3039	17136.0
2009-04-20 19:30:00	AAPL	Stock	4.3021	4.3046	4.3011	4.3011	110992.0
2009-04-20 07:00:00	MSFT	Stock	19.2	19.2	19.2	19.2	190.0
2009-04-20 07:30:00	MSFT	Stock	19.0	19.19	19.0	19.0	2100.0
2009-04-20 08:00:00	MSFT	Stock	19.12	19.12	18.86	18.86	71545.0
2009-04-20 08:30:00	MSFT	Stock	18.9	18.96	18.85	18.88	38312.0
2009-04-20 09:00:00	MSFT	Stock	18.88	18.9	18.81	18.9	16911.0
2009-04-20 09:30:00	MSFT	Stock	18.9	18.95	18.7	18.727	6008131.0
2009-04-20 10:00:00	MSFT	Stock	18.72	18.87	18.64	18.67	6730593.0
2009-04-20 10:30:00	MSFT	Stock	18.67	18.74	18.61	18.7	4988627.0
2009-04-20 11:00:00	MSFT	Stock	18.7	18.83	18.65	18.798	3776484.0
2009-04-20 11:30:00	MSFT	Stock	18.8	18.8	18.65	18.68	2523692.0
2009-04-20 12:00:00	MSFT	Stock	18.69	18.75	18.62	18.69	2972492.0
2009-04-20 12:30:00	MSFT	Stock	18.705	18.85	18.67	18.844	1957080.0
2009-04-20 13:00:00	MSFT	Stock	18.84	18.89	18.76	18.83	1703382.0
2009-04-20 13:30:00	MSFT	Stock	18.84	18.88	18.75	18.85	2941866.0
2009-04-20 14:00:00	MSFT	Stock	18.85	18.87	18.77	18.77	2609015.0
2009-04-20 14:30:00	MSFT	Stock	18.78	18.8	18.68	18.68	2205555.0
2009-04-20 15:00:00	MSFT	Stock	18.69	18.76	18.63	18.64	3568658.0
2009-04-20 15:30:00	MSFT	Stock	18.65	18.8	18.57	18.61	12791355.0
2009-04-20 16:00:00	MSFT	Stock	18.58	18.737	18.56	18.58	6530184.0
2009-04-20 16:30:00	MSFT	Stock	18.6	18.68	18.59	18.63	88127.0

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

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