PREVIEW / etf_30min / 2011-10-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-20.parquet
  size:    279 KB
  rows:    9,237

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-10-20 04:00:00	SPY	ETF	121.18	121.39	121.15	121.39	11298.0
2011-10-20 04:30:00	SPY	ETF	121.3	121.35	121.19	121.19	13161.0
2011-10-20 05:00:00	SPY	ETF	121.14	121.88	121.06	121.88	17450.0
2011-10-20 05:30:00	SPY	ETF	121.92	122.11	121.62	121.71	139624.0
2011-10-20 06:00:00	SPY	ETF	121.78	121.93	121.73	121.88	21900.0
2011-10-20 06:30:00	SPY	ETF	121.85	122.13	121.69	121.95	136368.0
2011-10-20 07:00:00	SPY	ETF	121.9	121.95	121.38	121.52	305650.0
2011-10-20 07:30:00	SPY	ETF	121.51	121.82	121.5	121.76	303088.0
2011-10-20 08:00:00	SPY	ETF	121.76	121.98	121.7	121.86	541190.0
2011-10-20 08:30:00	SPY	ETF	121.85	121.97	121.62	121.78	961993.0
2011-10-20 09:00:00	SPY	ETF	121.77	121.94	121.06	121.41	5766795.0
2011-10-20 09:30:00	SPY	ETF	121.43	121.52	120.87	121.04	27786704.0
2011-10-20 10:00:00	SPY	ETF	121.04	121.81	121.02	121.27	27012632.0
2011-10-20 10:30:00	SPY	ETF	121.27	121.55	120.64	120.641	19273981.0
2011-10-20 11:00:00	SPY	ETF	120.64	120.671	120.21	120.6	19107247.0
2011-10-20 11:30:00	SPY	ETF	120.59	120.82	120.09	120.27	14586430.0
2011-10-20 12:00:00	SPY	ETF	120.27	120.32	119.82	120.14	12970705.0
2011-10-20 12:30:00	SPY	ETF	120.14	120.8	120.1	120.68	10895169.0
2011-10-20 13:00:00	SPY	ETF	120.69	121.71	120.6	121.39	25650233.0
2011-10-20 13:30:00	SPY	ETF	121.4	121.62	120.97	121.18	20246690.0
2011-10-20 14:00:00	SPY	ETF	121.18	121.4299	120.87	121.23	11791711.0
2011-10-20 14:30:00	SPY	ETF	121.23	122.1	121.13	121.88	21071229.0
2011-10-20 15:00:00	SPY	ETF	121.88	121.96	121.2	121.34	11970091.0
2011-10-20 15:30:00	SPY	ETF	121.34	121.86	121.22	121.63	21626524.0
2011-10-20 16:00:00	SPY	ETF	121.64	121.75	121.1022	121.48	7721253.0
2011-10-20 16:30:00	SPY	ETF	121.47	121.59	121.14	121.56	227376.0
2011-10-20 17:00:00	SPY	ETF	121.54	121.56	121.46	121.46	72075.0
2011-10-20 17:30:00	SPY	ETF	121.46	121.52	121.46	121.5	42074.0
2011-10-20 18:00:00	SPY	ETF	121.49	121.69	121.49	121.52	115931.0
2011-10-20 18:30:00	SPY	ETF	121.55	121.64	121.55	121.57	9575.0
2011-10-20 19:00:00	SPY	ETF	121.55	121.58	121.46	121.5	85344.0
2011-10-20 19:30:00	SPY	ETF	121.5	121.61	121.47	121.6	40434.0
2011-10-20 05:00:00	QQQ	ETF	56.9	56.9	56.9	56.9	100.0
2011-10-20 05:30:00	QQQ	ETF	57.25	57.25	57.1	57.1	3100.0
2011-10-20 06:00:00	QQQ	ETF	57.25	57.25	57.24	57.24	300.0
2011-10-20 06:30:00	QQQ	ETF	57.24	57.27	57.24	57.27	2500.0
2011-10-20 07:00:00	QQQ	ETF	57.25	57.25	56.97	57.02	47100.0
2011-10-20 07:30:00	QQQ	ETF	57.04	57.2	57.03	57.16	68099.0
2011-10-20 08:00:00	QQQ	ETF	57.16	57.24	57.14	57.21	121158.0
2011-10-20 08:30:00	QQQ	ETF	57.19	57.2	57.08	57.13	238303.0
2011-10-20 09:00:00	QQQ	ETF	57.12	57.16	56.78	56.81	1008421.0
2011-10-20 09:30:00	QQQ	ETF	56.81	56.92	56.44	56.57	8829084.0
2011-10-20 10:00:00	QQQ	ETF	56.555	56.86	56.511	56.61	6363227.0
2011-10-20 10:30:00	QQQ	ETF	56.62	56.805	56.37	56.38	4428499.0
2011-10-20 11:00:00	QQQ	ETF	56.38	56.38	56.09	56.24	4546502.0
2011-10-20 11:30:00	QQQ	ETF	56.24	56.34	56.0	56.1	3041377.0
2011-10-20 12:00:00	QQQ	ETF	56.1084	56.14	55.79	56.0	5959330.0
2011-10-20 12:30:00	QQQ	ETF	56.0	56.27	55.99	56.25	3955330.0
2011-10-20 13:00:00	QQQ	ETF	56.25	56.71	56.22	56.6	7616126.0
2011-10-20 13:30:00	QQQ	ETF	56.61	56.67	56.42	56.52	5342843.0

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

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