PREVIEW / etf_30min / 2011-07-19

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-07-19.parquet
  size:    284 KB
  rows:    9,529

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
2011-07-19 04:00:00	SPY	ETF	131.21	131.25	131.2	131.2	2700.0
2011-07-19 04:30:00	SPY	ETF	131.3	131.35	131.25	131.35	1508.0
2011-07-19 05:00:00	SPY	ETF	131.37	131.58	131.35	131.45	3150.0
2011-07-19 05:30:00	SPY	ETF	131.39	131.39	131.3	131.3	800.0
2011-07-19 06:00:00	SPY	ETF	131.3	131.44	131.3	131.41	4500.0
2011-07-19 06:30:00	SPY	ETF	131.32	131.45	131.32	131.38	14300.0
2011-07-19 07:00:00	SPY	ETF	131.39	131.53	131.38	131.44	290749.0
2011-07-19 07:30:00	SPY	ETF	131.41	131.48	131.27	131.44	653831.0
2011-07-19 08:00:00	SPY	ETF	131.42	131.44	131.0	131.3	2746501.0
2011-07-19 08:30:00	SPY	ETF	131.32	131.57	131.12	131.32	3359309.0
2011-07-19 09:00:00	SPY	ETF	131.32	131.41	131.17	131.33	1714739.0
2011-07-19 09:30:00	SPY	ETF	131.34	131.92	131.31	131.77	18756920.0
2011-07-19 10:00:00	SPY	ETF	131.77	132.11	131.73	131.97	10562434.0
2011-07-19 10:30:00	SPY	ETF	131.97	132.08	131.87	131.94	6488830.0
2011-07-19 11:00:00	SPY	ETF	131.94	131.95	131.71	131.84	6897023.0
2011-07-19 11:30:00	SPY	ETF	131.835	131.88	131.51	131.65	11010639.0
2011-07-19 12:00:00	SPY	ETF	131.65	131.81	131.6	131.7	4767886.0
2011-07-19 12:30:00	SPY	ETF	131.69	131.93	131.64	131.82	8711948.0
2011-07-19 13:00:00	SPY	ETF	131.82	132.05	131.62	132.0371	6569149.0
2011-07-19 13:30:00	SPY	ETF	132.04	132.63	131.95	132.43	18776170.0
2011-07-19 14:00:00	SPY	ETF	132.42	132.48	132.24	132.45	10800550.0
2011-07-19 14:30:00	SPY	ETF	132.45	132.82	132.39	132.73	11683035.0
2011-07-19 15:00:00	SPY	ETF	132.73	132.89	132.62	132.68	10449274.0
2011-07-19 15:30:00	SPY	ETF	132.67	132.75	132.59	132.72	19110081.0
2011-07-19 16:00:00	SPY	ETF	132.74	132.87	132.1588	132.63	9107526.0
2011-07-19 16:30:00	SPY	ETF	132.61	132.95	132.1346	132.74	1746734.0
2011-07-19 17:00:00	SPY	ETF	132.75	132.81	132.66	132.8	401619.0
2011-07-19 17:30:00	SPY	ETF	132.79	132.8	132.77	132.78	90548.0
2011-07-19 18:00:00	SPY	ETF	132.79	132.79	132.69	132.75	457322.0
2011-07-19 18:30:00	SPY	ETF	132.74	132.76	132.71	132.73	103715.0
2011-07-19 19:00:00	SPY	ETF	132.73	132.8	132.69	132.78	8737.0
2011-07-19 19:30:00	SPY	ETF	132.78	132.89	132.77	132.89	99476.0
2011-07-19 20:00:00	SPY	ETF	132.86	132.86	132.86	132.86	200.0
2011-07-19 04:00:00	QQQ	ETF	57.79	57.79	57.79	57.79	300.0
2011-07-19 05:00:00	QQQ	ETF	57.93	57.99	57.91	57.99	25400.0
2011-07-19 05:30:00	QQQ	ETF	57.94	57.94	57.94	57.94	200.0
2011-07-19 06:00:00	QQQ	ETF	57.91	57.91	57.86	57.86	2400.0
2011-07-19 07:00:00	QQQ	ETF	57.9	57.96	57.9	57.96	11500.0
2011-07-19 07:30:00	QQQ	ETF	57.91	57.96	57.9	57.93	1260.0
2011-07-19 08:00:00	QQQ	ETF	57.94	58.0	57.83	57.98	1389118.0
2011-07-19 08:30:00	QQQ	ETF	57.98	58.15	57.98	58.14	2660438.0
2011-07-19 09:00:00	QQQ	ETF	58.15	58.16	58.03	58.11	1463939.0
2011-07-19 09:30:00	QQQ	ETF	58.12	58.55	58.09	58.46	10537850.0
2011-07-19 10:00:00	QQQ	ETF	58.46	58.64	58.42	58.57	3519507.0
2011-07-19 10:30:00	QQQ	ETF	58.575	58.63	58.51	58.53	2094640.0
2011-07-19 11:00:00	QQQ	ETF	58.53	58.54	58.4501	58.49	2201013.0
2011-07-19 11:30:00	QQQ	ETF	58.49	58.4984	58.36	58.465	3639757.0
2011-07-19 12:00:00	QQQ	ETF	58.465	58.505	58.41	58.44	1465088.0
2011-07-19 12:30:00	QQQ	ETF	58.44	58.55	58.43	58.52	2869477.0
2011-07-19 13:00:00	QQQ	ETF	58.52	58.59	58.4	58.56	1446121.0

> showing 50 of 9,529 rows — these rows as CSV

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