PREVIEW / stock_30min / 2010-02-26

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-02-26.parquet
  size:    1.3 MB
  rows:    72,272
  symbols: 3,453

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
2010-02-26 06:00:00	AAPL	Stock	7.2357	7.2357	7.2357	7.2357	5600.0
2010-02-26 06:30:00	AAPL	Stock	7.2343	7.2361	7.2343	7.2361	28000.0
2010-02-26 07:00:00	AAPL	Stock	7.235	7.2411	7.2236	7.2411	74340.0
2010-02-26 07:30:00	AAPL	Stock	7.2461	7.2464	7.2296	7.2296	456680.0
2010-02-26 08:00:00	AAPL	Stock	7.2286	7.2504	7.2143	7.2304	966448.0
2010-02-26 08:30:00	AAPL	Stock	7.2339	7.2571	7.225	7.2511	2400580.0
2010-02-26 09:00:00	AAPL	Stock	7.2511	7.2532	7.2275	7.2275	1369648.0
2010-02-26 09:30:00	AAPL	Stock	7.2279	7.2571	7.2143	7.24	70542108.0
2010-02-26 10:00:00	AAPL	Stock	7.2418	7.3214	7.2357	7.3111	99685880.0
2010-02-26 10:30:00	AAPL	Stock	7.3111	7.3275	7.2982	7.2993	57005172.0
2010-02-26 11:00:00	AAPL	Stock	7.2996	7.315	7.2904	7.3107	32766412.0
2010-02-26 11:30:00	AAPL	Stock	7.3104	7.3214	7.2975	7.3046	22765736.0
2010-02-26 12:00:00	AAPL	Stock	7.3043	7.3139	7.2929	7.3011	21299600.0
2010-02-26 12:30:00	AAPL	Stock	7.3011	7.3136	7.2943	7.3021	17997224.0
2010-02-26 13:00:00	AAPL	Stock	7.3021	7.3125	7.3011	7.3121	14739004.0
2010-02-26 13:30:00	AAPL	Stock	7.3121	7.3214	7.3021	7.3179	19331396.0
2010-02-26 14:00:00	AAPL	Stock	7.3179	7.3196	7.3089	7.3177	15278872.0
2010-02-26 14:30:00	AAPL	Stock	7.3179	7.3214	7.3111	7.3204	14681520.0
2010-02-26 15:00:00	AAPL	Stock	7.3211	7.3268	7.3025	7.3236	29328628.0
2010-02-26 15:30:00	AAPL	Stock	7.3236	7.325	7.2946	7.3086	63030492.0
2010-02-26 16:00:00	AAPL	Stock	7.3086	7.3132	7.2947	7.3075	13799772.0
2010-02-26 16:30:00	AAPL	Stock	7.3248	7.3248	7.3079	7.3093	1087940.0
2010-02-26 17:00:00	AAPL	Stock	7.3079	7.3121	7.3079	7.3089	451136.0
2010-02-26 17:30:00	AAPL	Stock	7.3086	7.3096	7.3071	7.3086	103964.0
2010-02-26 18:00:00	AAPL	Stock	7.3089	7.3089	7.3071	7.3079	92036.0
2010-02-26 18:30:00	AAPL	Stock	7.3089	7.3093	7.3079	7.3093	22288.0
2010-02-26 19:00:00	AAPL	Stock	7.3096	7.3143	7.3071	7.3139	98420.0
2010-02-26 19:30:00	AAPL	Stock	7.315	7.3154	7.3107	7.3107	173152.0
2010-02-26 06:00:00	MSFT	Stock	28.8	28.8	28.8	28.8	100.0
2010-02-26 08:00:00	MSFT	Stock	28.55	28.64	28.54	28.64	30276.0
2010-02-26 08:30:00	MSFT	Stock	28.63	28.66	28.63	28.65	12400.0
2010-02-26 09:00:00	MSFT	Stock	28.64	28.68	28.61	28.65	9000.0
2010-02-26 09:30:00	MSFT	Stock	28.65	28.67	28.51	28.61	3462850.0
2010-02-26 10:00:00	MSFT	Stock	28.62	28.85	28.58	28.76	4765071.0
2010-02-26 10:30:00	MSFT	Stock	28.76	28.84	28.68	28.7	2419240.0
2010-02-26 11:00:00	MSFT	Stock	28.7	28.8	28.67	28.768	1761778.0
2010-02-26 11:30:00	MSFT	Stock	28.76	28.84	28.74	28.79	2119941.0
2010-02-26 12:00:00	MSFT	Stock	28.79	28.8	28.69	28.725	1544858.0
2010-02-26 12:30:00	MSFT	Stock	28.73	28.75	28.65	28.745	1900723.0
2010-02-26 13:00:00	MSFT	Stock	28.75	28.79	28.71	28.771	1170484.0
2010-02-26 13:30:00	MSFT	Stock	28.77	28.8	28.72	28.765	1861356.0
2010-02-26 14:00:00	MSFT	Stock	28.77	28.77	28.7	28.74	1256585.0
2010-02-26 14:30:00	MSFT	Stock	28.74	28.76	28.68	28.76	1201540.0
2010-02-26 15:00:00	MSFT	Stock	28.755	28.79	28.7	28.73	1996901.0
2010-02-26 15:30:00	MSFT	Stock	28.74	28.81	28.67	28.67	6745976.0
2010-02-26 16:00:00	MSFT	Stock	28.68	28.753	28.648	28.65	5379349.0
2010-02-26 16:30:00	MSFT	Stock	28.723	28.723	28.66	28.67	273244.0
2010-02-26 17:00:00	MSFT	Stock	28.66	28.67	28.66	28.67	78623.0
2010-02-26 17:30:00	MSFT	Stock	28.67	28.67	28.67	28.67	500.0
2010-02-26 18:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	100.0

> showing 50 of 72,272 rows — these rows as CSV

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