PREVIEW / stock_30min / 2010-05-27

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-05-27.parquet
  size:    1.4 MB
  rows:    74,493
  symbols: 3,468

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-05-27 04:00:00	AAPL	Stock	8.8818	8.8818	8.825	8.8618	19600.0
2010-05-27 04:30:00	AAPL	Stock	8.9071	8.9071	8.9071	8.9071	14000.0
2010-05-27 05:00:00	AAPL	Stock	8.9071	8.9111	8.9071	8.9111	8400.0
2010-05-27 06:00:00	AAPL	Stock	8.9143	8.9571	8.9143	8.9571	11200.0
2010-05-27 06:30:00	AAPL	Stock	8.9571	8.9571	8.9571	8.9571	25200.0
2010-05-27 07:00:00	AAPL	Stock	8.9439	8.9629	8.9021	8.9175	996408.0
2010-05-27 07:30:00	AAPL	Stock	8.9161	8.9282	8.9064	8.9186	237776.0
2010-05-27 08:00:00	AAPL	Stock	8.9146	8.9286	8.9071	8.9179	2698780.0
2010-05-27 08:30:00	AAPL	Stock	8.9179	8.9179	8.8932	8.9107	3237360.0
2010-05-27 09:00:00	AAPL	Stock	8.9107	8.9554	8.9089	8.95	3046036.0
2010-05-27 09:30:00	AAPL	Stock	8.95	8.9821	8.8968	8.9336	116941160.0
2010-05-27 10:00:00	AAPL	Stock	8.9336	8.9679	8.9107	8.9679	64057812.0
2010-05-27 10:30:00	AAPL	Stock	8.9675	8.9682	8.9143	8.9357	53724748.0
2010-05-27 11:00:00	AAPL	Stock	8.9352	8.9643	8.9286	8.9629	35569184.0
2010-05-27 11:30:00	AAPL	Stock	8.9625	8.9679	8.945	8.9604	41210176.0
2010-05-27 12:00:00	AAPL	Stock	8.9604	8.9629	8.9396	8.9557	30653728.0
2010-05-27 12:30:00	AAPL	Stock	8.9557	8.9607	8.9396	8.9521	20039544.0
2010-05-27 13:00:00	AAPL	Stock	8.9532	8.9675	8.9289	8.9632	29212820.0
2010-05-27 13:30:00	AAPL	Stock	8.9636	8.9907	8.9582	8.9707	42099792.0
2010-05-27 14:00:00	AAPL	Stock	8.9706	8.9993	8.9614	8.9929	34655488.0
2010-05-27 14:30:00	AAPL	Stock	8.9929	9.0064	8.9714	8.9848	34755728.0
2010-05-27 15:00:00	AAPL	Stock	8.9846	9.0218	8.9714	8.9869	42921424.0
2010-05-27 15:30:00	AAPL	Stock	8.9875	9.0675	8.9846	9.0532	74371416.0
2010-05-27 16:00:00	AAPL	Stock	9.0532	9.0661	8.9445	9.0618	24506440.0
2010-05-27 16:30:00	AAPL	Stock	9.0607	9.0643	8.9856	9.0625	613424.0
2010-05-27 17:00:00	AAPL	Stock	9.0625	9.0711	8.9451	9.0679	2776424.0
2010-05-27 17:30:00	AAPL	Stock	9.0711	9.0911	9.0686	9.0911	503860.0
2010-05-27 18:00:00	AAPL	Stock	9.0929	9.1589	9.0482	9.1221	2988776.0
2010-05-27 18:30:00	AAPL	Stock	9.125	9.1382	9.1164	9.1246	282940.0
2010-05-27 19:00:00	AAPL	Stock	9.1182	9.1221	9.1079	9.1168	329560.0
2010-05-27 19:30:00	AAPL	Stock	9.1132	9.1429	9.1125	9.1429	479864.0
2010-05-27 04:00:00	MSFT	Stock	25.61	25.61	25.31	25.42	38919.0
2010-05-27 04:30:00	MSFT	Stock	25.44	25.57	25.44	25.57	2400.0
2010-05-27 05:00:00	MSFT	Stock	25.59	25.59	25.59	25.59	100.0
2010-05-27 05:30:00	MSFT	Stock	25.6	25.6	25.6	25.6	2500.0
2010-05-27 06:00:00	MSFT	Stock	25.69	25.69	25.6	25.6	7300.0
2010-05-27 06:30:00	MSFT	Stock	25.69	25.79	25.69	25.79	53769.0
2010-05-27 07:00:00	MSFT	Stock	25.8	25.8	25.7	25.7	49150.0
2010-05-27 07:30:00	MSFT	Stock	25.7	25.76	25.7	25.76	67548.0
2010-05-27 08:00:00	MSFT	Stock	25.75	25.77	25.61	25.7	988694.0
2010-05-27 08:30:00	MSFT	Stock	25.7	25.7	25.43	25.57	489854.0
2010-05-27 09:00:00	MSFT	Stock	25.56	25.74	25.55	25.74	1127098.0
2010-05-27 09:30:00	MSFT	Stock	25.73	26.29	25.725	26.02	32499245.0
2010-05-27 10:00:00	MSFT	Stock	26.02	26.28	25.97	26.25	10857169.0
2010-05-27 10:30:00	MSFT	Stock	26.245	26.352	26.2	26.26	9148591.0
2010-05-27 11:00:00	MSFT	Stock	26.255	26.36	26.23	26.34	5384862.0
2010-05-27 11:30:00	MSFT	Stock	26.349	26.35	26.14	26.18	7708904.0
2010-05-27 12:00:00	MSFT	Stock	26.18	26.19	26.01	26.09	7989386.0
2010-05-27 12:30:00	MSFT	Stock	26.08	26.09	25.97	26.02	5207584.0
2010-05-27 13:00:00	MSFT	Stock	26.02	26.09	25.99	26.03	5551138.0

> showing 50 of 74,493 rows — these rows as CSV

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