PREVIEW / stock_30min / 2012-03-15

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-03-15.parquet
  size:    1.4 MB
  rows:    76,630
  symbols: 3,515

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
2012-03-15 04:00:00	AAPL	Stock	21.3036	21.3571	21.2496	21.2589	262276.0
2012-03-15 04:30:00	AAPL	Stock	21.2625	21.2861	21.1857	21.2857	127848.0
2012-03-15 05:00:00	AAPL	Stock	21.2875	21.3168	21.2875	21.3	82880.0
2012-03-15 05:30:00	AAPL	Stock	21.3	21.3	21.2904	21.3	97300.0
2012-03-15 06:00:00	AAPL	Stock	21.2893	21.2893	21.2679	21.2679	44800.0
2012-03-15 06:30:00	AAPL	Stock	21.2696	21.2964	21.2696	21.2929	78232.0
2012-03-15 07:00:00	AAPL	Stock	21.2929	21.3493	21.2786	21.3318	1404592.0
2012-03-15 07:30:00	AAPL	Stock	21.3214	21.3571	21.2714	21.2825	1577996.0
2012-03-15 08:00:00	AAPL	Stock	21.2768	21.3882	21.2732	21.3832	7119392.0
2012-03-15 08:30:00	AAPL	Stock	21.3846	21.4171	21.36	21.3975	7640304.0
2012-03-15 09:00:00	AAPL	Stock	21.3929	21.4318	21.3607	21.4104	9151156.0
2012-03-15 09:30:00	AAPL	Stock	21.4104	21.4289	21.1964	21.2782	202130908.0
2012-03-15 10:00:00	AAPL	Stock	21.2791	21.3061	20.8596	21.1156	177412144.0
2012-03-15 10:30:00	AAPL	Stock	21.1146	21.2364	21.1029	21.1389	73928596.0
2012-03-15 11:00:00	AAPL	Stock	21.1357	21.2132	21.0114	21.1784	58518208.0
2012-03-15 11:30:00	AAPL	Stock	21.1779	21.2049	21.1072	21.1321	30703652.0
2012-03-15 12:00:00	AAPL	Stock	21.1332	21.1807	21.0718	21.14	36784132.0
2012-03-15 12:30:00	AAPL	Stock	21.1394	21.1482	21.0575	21.0575	37470440.0
2012-03-15 13:00:00	AAPL	Stock	21.0574	21.1136	20.9039	20.9221	59232404.0
2012-03-15 13:30:00	AAPL	Stock	20.9221	21.026	20.7579	20.8307	109009460.0
2012-03-15 14:00:00	AAPL	Stock	20.8304	20.9357	20.6625	20.8878	107142924.0
2012-03-15 14:30:00	AAPL	Stock	20.8868	21.0871	20.8329	20.9804	62552084.0
2012-03-15 15:00:00	AAPL	Stock	20.9853	21.0339	20.88	20.9871	54162836.0
2012-03-15 15:30:00	AAPL	Stock	20.9864	21.0179	20.7989	20.9071	87087280.0
2012-03-15 16:00:00	AAPL	Stock	20.9075	21.1685	20.7661	20.9025	22316532.0
2012-03-15 16:30:00	AAPL	Stock	20.8971	21.0611	20.8925	20.8929	1212176.0
2012-03-15 17:00:00	AAPL	Stock	20.8982	20.9104	20.8786	20.8804	476532.0
2012-03-15 17:30:00	AAPL	Stock	20.8821	20.8964	20.8754	20.8929	567112.0
2012-03-15 18:00:00	AAPL	Stock	20.8964	20.9032	20.8839	20.8982	150472.0
2012-03-15 18:30:00	AAPL	Stock	20.8939	20.9018	20.8875	20.8875	290472.0
2012-03-15 19:00:00	AAPL	Stock	20.8882	20.8993	20.8839	20.8993	198240.0
2012-03-15 19:30:00	AAPL	Stock	20.8982	20.9243	20.8971	20.9036	475132.0
2012-03-15 04:00:00	MSFT	Stock	32.78	32.8	32.78	32.8	900.0
2012-03-15 05:00:00	MSFT	Stock	32.8	32.8	32.8	32.8	100.0
2012-03-15 05:30:00	MSFT	Stock	32.8	32.8	32.8	32.8	100.0
2012-03-15 06:00:00	MSFT	Stock	32.74	32.74	32.69	32.74	2700.0
2012-03-15 07:00:00	MSFT	Stock	32.77	32.77	32.77	32.77	330.0
2012-03-15 07:30:00	MSFT	Stock	32.8	32.8	32.8	32.8	1000.0
2012-03-15 08:00:00	MSFT	Stock	32.77	32.77	32.77	32.77	5530.0
2012-03-15 08:30:00	MSFT	Stock	32.77	32.8	32.77	32.8	7166.0
2012-03-15 09:00:00	MSFT	Stock	32.81	32.81	32.73	32.79	51876.0
2012-03-15 09:30:00	MSFT	Stock	32.79	32.84	32.58	32.81	4250389.0
2012-03-15 10:00:00	MSFT	Stock	32.8	32.94	32.77	32.915	3928486.0
2012-03-15 10:30:00	MSFT	Stock	32.92	32.93	32.85	32.85	2474752.0
2012-03-15 11:00:00	MSFT	Stock	32.857	32.897	32.81	32.86	1864826.0
2012-03-15 11:30:00	MSFT	Stock	32.868	32.9	32.85	32.88	1684197.0
2012-03-15 12:00:00	MSFT	Stock	32.89	32.94	32.85	32.926	2196796.0
2012-03-15 12:30:00	MSFT	Stock	32.925	32.93	32.85	32.869	1242119.0
2012-03-15 13:00:00	MSFT	Stock	32.87	32.89	32.79	32.81	3235774.0
2012-03-15 13:30:00	MSFT	Stock	32.81	32.87	32.805	32.83	5039755.0

> showing 50 of 76,630 rows — these rows as CSV

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