PREVIEW / etf_30min / 2011-06-07

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-06-07.parquet
  size:    280 KB
  rows:    9,367

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-06-07 04:00:00	SPY	ETF	129.41	129.74	129.41	129.71	5760.0
2011-06-07 04:30:00	SPY	ETF	129.75	129.88	129.62	129.79	2900.0
2011-06-07 05:00:00	SPY	ETF	129.78	129.8	129.67	129.67	600.0
2011-06-07 05:30:00	SPY	ETF	129.6	129.72	129.5	129.72	1985.0
2011-06-07 06:00:00	SPY	ETF	129.73	129.87	129.65	129.87	14310.0
2011-06-07 06:30:00	SPY	ETF	129.88	129.9	129.7	129.7	104700.0
2011-06-07 07:00:00	SPY	ETF	129.72	129.74	129.54	129.59	159395.0
2011-06-07 07:30:00	SPY	ETF	129.56	129.69	129.55	129.58	423399.0
2011-06-07 08:00:00	SPY	ETF	129.57	129.68	129.45	129.63	1197886.0
2011-06-07 08:30:00	SPY	ETF	129.64	129.78	129.55	129.77	1450248.0
2011-06-07 09:00:00	SPY	ETF	129.77	129.85	129.69	129.7	1674224.0
2011-06-07 09:30:00	SPY	ETF	129.7	129.74	129.35	129.55	21689738.0
2011-06-07 10:00:00	SPY	ETF	129.55	129.92	129.53	129.75	14062468.0
2011-06-07 10:30:00	SPY	ETF	129.75	129.99	129.64	129.91	9994636.0
2011-06-07 11:00:00	SPY	ETF	129.91	129.93	129.64	129.65	6533718.0
2011-06-07 11:30:00	SPY	ETF	129.645	129.7	129.46	129.67	8918031.0
2011-06-07 12:00:00	SPY	ETF	129.68	129.76	129.55	129.66	6016873.0
2011-06-07 12:30:00	SPY	ETF	129.66	129.8	129.52	129.77	4133635.0
2011-06-07 13:00:00	SPY	ETF	129.77	129.92	129.68	129.74	6074436.0
2011-06-07 13:30:00	SPY	ETF	129.75	129.88	129.69	129.76	4616057.0
2011-06-07 14:00:00	SPY	ETF	129.76	130.07	129.74	130.03	7427419.0
2011-06-07 14:30:00	SPY	ETF	130.02	130.03	129.69	129.8	7658336.0
2011-06-07 15:00:00	SPY	ETF	129.8	129.87	129.5	129.58	10612373.0
2011-06-07 15:30:00	SPY	ETF	129.575	129.59	128.87	128.94	37365273.0
2011-06-07 16:00:00	SPY	ETF	128.93	129.65	128.79	129.03	9542012.0
2011-06-07 16:30:00	SPY	ETF	129.04	129.15	129.01	129.11	528980.0
2011-06-07 17:00:00	SPY	ETF	129.09	129.26	129.07	129.25	365903.0
2011-06-07 17:30:00	SPY	ETF	129.27	129.33	129.23	129.29	211336.0
2011-06-07 18:00:00	SPY	ETF	129.28	129.29	128.85	129.19	90014.0
2011-06-07 18:30:00	SPY	ETF	129.16	129.24	129.16	129.18	71025.0
2011-06-07 19:00:00	SPY	ETF	129.17	129.21	129.15	129.19	74500.0
2011-06-07 19:30:00	SPY	ETF	129.2	129.25	129.19	129.2	95686.0
2011-06-07 06:30:00	QQQ	ETF	56.15	56.17	56.14	56.17	5200.0
2011-06-07 07:00:00	QQQ	ETF	56.11	56.11	56.05	56.09	17139.0
2011-06-07 07:30:00	QQQ	ETF	56.09	56.11	56.05	56.08	17997.0
2011-06-07 08:00:00	QQQ	ETF	56.09	56.11	56.02	56.09	203432.0
2011-06-07 08:30:00	QQQ	ETF	56.08	56.14	56.05	56.14	102270.0
2011-06-07 09:00:00	QQQ	ETF	56.15	56.18	56.05	56.05	327420.0
2011-06-07 09:30:00	QQQ	ETF	56.05	56.08	55.88	55.99	5035524.0
2011-06-07 10:00:00	QQQ	ETF	55.99	56.17	55.98	56.08	4667738.0
2011-06-07 10:30:00	QQQ	ETF	56.09	56.2	56.07	56.17	1983385.0
2011-06-07 11:00:00	QQQ	ETF	56.17	56.18	55.96	55.97	3265113.0
2011-06-07 11:30:00	QQQ	ETF	55.97	56.015	55.9	55.99	2064934.0
2011-06-07 12:00:00	QQQ	ETF	56.0	56.01	55.92	55.945	907166.0
2011-06-07 12:30:00	QQQ	ETF	55.94	56.0099	55.89	56.0	1381401.0
2011-06-07 13:00:00	QQQ	ETF	56.0	56.13	55.98	56.065	2054548.0
2011-06-07 13:30:00	QQQ	ETF	56.07	56.1	56.02	56.065	1894567.0
2011-06-07 14:00:00	QQQ	ETF	56.07	56.26	56.05	56.23	2580821.0
2011-06-07 14:30:00	QQQ	ETF	56.23	56.23	56.045	56.09	1544163.0
2011-06-07 15:00:00	QQQ	ETF	56.08	56.13	55.945	55.99	1724821.0

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

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