PREVIEW / stock_30min / 2014-01-03

all stock 30-min files

  file:    by_date/stock_30min/2014/2014-01-03.parquet
  size:    1.6 MB
  rows:    80,558
  symbols: 3,512

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
2014-01-03 04:30:00	AAPL	Stock	19.7607	19.7607	19.7607	19.7607	2800.0
2014-01-03 05:00:00	AAPL	Stock	19.7607	19.7607	19.7607	19.7607	14000.0
2014-01-03 06:00:00	AAPL	Stock	19.7732	19.7732	19.7732	19.7732	3920.0
2014-01-03 06:30:00	AAPL	Stock	19.7979	19.8	19.7979	19.8	15512.0
2014-01-03 07:00:00	AAPL	Stock	19.8	19.8279	19.7864	19.8014	90664.0
2014-01-03 07:30:00	AAPL	Stock	19.8036	19.8179	19.7968	19.8139	95928.0
2014-01-03 08:00:00	AAPL	Stock	19.8111	19.8214	19.7946	19.7946	718172.0
2014-01-03 08:30:00	AAPL	Stock	19.7911	19.8036	19.7786	19.7786	404852.0
2014-01-03 09:00:00	AAPL	Stock	19.7786	19.7814	19.75	19.75	635236.0
2014-01-03 09:30:00	AAPL	Stock	19.7454	19.775	19.5464	19.5825	56693168.0
2014-01-03 10:00:00	AAPL	Stock	19.5839	19.5975	19.5043	19.5096	29085168.0
2014-01-03 10:30:00	AAPL	Stock	19.5096	19.5314	19.4868	19.5171	27083364.0
2014-01-03 11:00:00	AAPL	Stock	19.5161	19.5611	19.5029	19.5046	20134772.0
2014-01-03 11:30:00	AAPL	Stock	19.5018	19.5089	19.4532	19.4719	18897508.0
2014-01-03 12:00:00	AAPL	Stock	19.4707	19.4739	19.4225	19.4243	14102984.0
2014-01-03 12:30:00	AAPL	Stock	19.4239	19.4257	19.3729	19.3993	24517500.0
2014-01-03 13:00:00	AAPL	Stock	19.3993	19.4279	19.3761	19.4179	12564048.0
2014-01-03 13:30:00	AAPL	Stock	19.4203	19.4529	19.3882	19.4493	12044228.0
2014-01-03 14:00:00	AAPL	Stock	19.4518	19.4607	19.4118	19.4387	9464672.0
2014-01-03 14:30:00	AAPL	Stock	19.4389	19.4811	19.42	19.4593	12866672.0
2014-01-03 15:00:00	AAPL	Stock	19.4571	19.4743	19.4479	19.4511	12108656.0
2014-01-03 15:30:00	AAPL	Stock	19.4518	19.4546	19.3011	19.3229	54467224.0
2014-01-03 16:00:00	AAPL	Stock	19.3229	19.4812	19.3168	19.3321	15011416.0
2014-01-03 16:30:00	AAPL	Stock	19.3318	19.3571	19.2986	19.3196	1204364.0
2014-01-03 17:00:00	AAPL	Stock	19.3089	19.3268	19.3089	19.3143	1635480.0
2014-01-03 17:30:00	AAPL	Stock	19.3207	19.3214	19.3046	19.3179	272972.0
2014-01-03 18:00:00	AAPL	Stock	19.3214	19.3221	19.31	19.3168	72268.0
2014-01-03 18:30:00	AAPL	Stock	19.3096	19.3254	19.3036	19.3204	71120.0
2014-01-03 19:00:00	AAPL	Stock	19.3139	19.3186	19.3075	19.3179	83356.0
2014-01-03 19:30:00	AAPL	Stock	19.3175	19.3214	19.3036	19.3079	142464.0
2014-01-03 04:30:00	MSFT	Stock	37.16	37.16	37.16	37.16	100.0
2014-01-03 08:30:00	MSFT	Stock	37.19	37.25	37.19	37.25	560.0
2014-01-03 09:00:00	MSFT	Stock	37.2	37.289	37.2	37.2	895.0
2014-01-03 09:30:00	MSFT	Stock	37.2	37.22	37.0	37.037	2768916.0
2014-01-03 10:00:00	MSFT	Stock	37.04	37.09	36.86	36.86	2077059.0
2014-01-03 10:30:00	MSFT	Stock	36.87	36.91	36.74	36.81	2366629.0
2014-01-03 11:00:00	MSFT	Stock	36.81	36.885	36.69	36.725	1819939.0
2014-01-03 11:30:00	MSFT	Stock	36.72	36.77	36.6	36.759	2561214.0
2014-01-03 12:00:00	MSFT	Stock	36.76	36.81	36.75	36.8	940323.0
2014-01-03 12:30:00	MSFT	Stock	36.8	36.89	36.77	36.809	1140668.0
2014-01-03 13:00:00	MSFT	Stock	36.805	36.85	36.76	36.85	1099710.0
2014-01-03 13:30:00	MSFT	Stock	36.84	36.85	36.78	36.8	1016723.0
2014-01-03 14:00:00	MSFT	Stock	36.8	36.85	36.75	36.85	1274349.0
2014-01-03 14:30:00	MSFT	Stock	36.842	36.94	36.84	36.905	1255336.0
2014-01-03 15:00:00	MSFT	Stock	36.9	36.98	36.9	36.95	2183176.0
2014-01-03 15:30:00	MSFT	Stock	36.94	36.99	36.9	36.92	5117946.0
2014-01-03 16:00:00	MSFT	Stock	36.9	37.21	36.808	36.91	4325338.0
2014-01-03 16:30:00	MSFT	Stock	36.9	36.93	36.86	36.86	17162.0
2014-01-03 17:00:00	MSFT	Stock	36.86	36.97	36.86	36.91	35739.0
2014-01-03 09:00:00	NVDA	Stock	0.3973	0.3973	0.3973	0.3973	4000.0

> showing 50 of 80,558 rows — these rows as CSV

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