PREVIEW / etf_30min / 2011-08-24

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-08-24.parquet
  size:    291 KB
  rows:    9,608

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-08-24 04:00:00	SPY	ETF	115.45	115.67	114.99	115.58	17515.0
2011-08-24 04:30:00	SPY	ETF	115.5	115.54	115.5	115.54	333.0
2011-08-24 05:00:00	SPY	ETF	115.46	115.9	115.46	115.8	5100.0
2011-08-24 05:30:00	SPY	ETF	115.79	115.83	115.5	115.74	2438.0
2011-08-24 06:00:00	SPY	ETF	115.6	115.68	115.51	115.51	15650.0
2011-08-24 06:30:00	SPY	ETF	115.66	115.66	115.22	115.3	142073.0
2011-08-24 07:00:00	SPY	ETF	115.27	115.82	115.25	115.72	560645.0
2011-08-24 07:30:00	SPY	ETF	115.69	115.79	115.35	115.4	361445.0
2011-08-24 08:00:00	SPY	ETF	115.39	115.6	115.36	115.51	2050508.0
2011-08-24 08:30:00	SPY	ETF	115.53	116.51	115.5	116.32	5022028.0
2011-08-24 09:00:00	SPY	ETF	116.32	116.41	115.43	116.2	2042396.0
2011-08-24 09:30:00	SPY	ETF	116.19	117.49	115.92	117.4	27751718.0
2011-08-24 10:00:00	SPY	ETF	117.43	117.94	117.14	117.2	32699537.0
2011-08-24 10:30:00	SPY	ETF	117.21	117.38	116.58	116.58	20751150.0
2011-08-24 11:00:00	SPY	ETF	116.58	117.04	116.43	116.855	15085930.0
2011-08-24 11:30:00	SPY	ETF	116.85	117.02	116.4	116.48	13853761.0
2011-08-24 12:00:00	SPY	ETF	116.48	116.48	115.95	116.275	13230252.0
2011-08-24 12:30:00	SPY	ETF	116.27	116.72	116.12	116.67	8807203.0
2011-08-24 13:00:00	SPY	ETF	116.675	117.31	116.5	117.14	11223480.0
2011-08-24 13:30:00	SPY	ETF	117.14	117.22	116.69	117.14	9174275.0
2011-08-24 14:00:00	SPY	ETF	117.14	117.24	116.73	116.85	7837277.0
2011-08-24 14:30:00	SPY	ETF	116.85	117.37	116.8	117.31	10536394.0
2011-08-24 15:00:00	SPY	ETF	117.31	117.82	117.15	117.715	15446033.0
2011-08-24 15:30:00	SPY	ETF	117.72	118.24	117.71	118.09	29763846.0
2011-08-24 16:00:00	SPY	ETF	118.06	118.15	117.68	117.8	14798544.0
2011-08-24 16:30:00	SPY	ETF	117.76	117.95	117.61	117.68	2453140.0
2011-08-24 17:00:00	SPY	ETF	117.69	117.85	117.63	117.7	176695.0
2011-08-24 17:30:00	SPY	ETF	117.74	117.82	117.66	117.74	40743.0
2011-08-24 18:00:00	SPY	ETF	117.74	118.13	117.43	117.51	1385776.0
2011-08-24 18:30:00	SPY	ETF	117.47	117.51	117.12	117.33	360701.0
2011-08-24 19:00:00	SPY	ETF	117.28	117.32	117.2	117.26	113090.0
2011-08-24 19:30:00	SPY	ETF	117.29	117.41	117.27	117.36	246610.0
2011-08-24 04:00:00	QQQ	ETF	51.84	51.84	51.63	51.73	7371.0
2011-08-24 04:30:00	QQQ	ETF	51.85	51.85	51.82	51.82	600.0
2011-08-24 05:00:00	QQQ	ETF	52.0	52.0	52.0	52.0	200.0
2011-08-24 06:00:00	QQQ	ETF	51.9	51.9	51.83	51.83	1000.0
2011-08-24 06:30:00	QQQ	ETF	51.8	51.8	51.7	51.79	27300.0
2011-08-24 07:00:00	QQQ	ETF	51.75	51.94	51.71	51.9	19950.0
2011-08-24 07:30:00	QQQ	ETF	51.89	51.94	51.79	51.82	44438.0
2011-08-24 08:00:00	QQQ	ETF	51.8	51.91	51.8	51.85	404090.0
2011-08-24 08:30:00	QQQ	ETF	51.83	52.27	51.83	52.21	743478.0
2011-08-24 09:00:00	QQQ	ETF	52.21	52.26	52.09	52.19	329649.0
2011-08-24 09:30:00	QQQ	ETF	52.18	52.65	52.01	52.62	7960273.0
2011-08-24 10:00:00	QQQ	ETF	52.62	53.42	52.34	52.38	9597139.0
2011-08-24 10:30:00	QQQ	ETF	52.38	52.45	52.03	52.04	4929712.0
2011-08-24 11:00:00	QQQ	ETF	52.0399	52.24	51.89	52.16	4182404.0
2011-08-24 11:30:00	QQQ	ETF	52.16	52.22	51.94	51.97	3003611.0
2011-08-24 12:00:00	QQQ	ETF	51.95	51.95	51.71	51.89	4004066.0
2011-08-24 12:30:00	QQQ	ETF	51.9	52.17	51.85	52.14	2723109.0
2011-08-24 13:00:00	QQQ	ETF	52.14	52.41	52.06	52.3	3202007.0

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

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