PREVIEW / etf_30min / 2012-12-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-07.parquet
  size:    280 KB
  rows:    9,647

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
2012-12-07 04:00:00	SPY	ETF	141.9	141.91	141.79	141.84	30600.0
2012-12-07 04:30:00	SPY	ETF	141.91	141.94	141.86	141.86	6000.0
2012-12-07 05:00:00	SPY	ETF	141.9	141.9	141.9	141.9	14394.0
2012-12-07 05:30:00	SPY	ETF	141.85	141.87	141.85	141.87	700.0
2012-12-07 06:00:00	SPY	ETF	141.82	141.84	141.73	141.73	7873.0
2012-12-07 06:30:00	SPY	ETF	141.75	141.93	141.75	141.93	35700.0
2012-12-07 07:00:00	SPY	ETF	141.93	141.94	141.78	141.79	74744.0
2012-12-07 07:30:00	SPY	ETF	141.81	141.81	141.59	141.68	182937.0
2012-12-07 08:00:00	SPY	ETF	141.68	141.87	141.57	141.6	906787.0
2012-12-07 08:30:00	SPY	ETF	141.98	142.91	141.69	142.57	4406212.0
2012-12-07 09:00:00	SPY	ETF	142.58	142.64	142.34	142.53	1346053.0
2012-12-07 09:30:00	SPY	ETF	142.53	142.69	142.04	142.14	14116766.0
2012-12-07 10:00:00	SPY	ETF	142.14	142.48	142.07	142.16	8294926.0
2012-12-07 10:30:00	SPY	ETF	142.17	142.19	141.84	141.96	8176026.0
2012-12-07 11:00:00	SPY	ETF	141.96	142.12	141.67	142.05	9233256.0
2012-12-07 11:30:00	SPY	ETF	142.05	142.18	141.85	141.87	5745088.0
2012-12-07 12:00:00	SPY	ETF	141.87	142.14	141.85	142.035	4931331.0
2012-12-07 12:30:00	SPY	ETF	142.03	142.11	141.92	142.09	3221435.0
2012-12-07 13:00:00	SPY	ETF	142.085	142.26	142.05	142.185	5141878.0
2012-12-07 13:30:00	SPY	ETF	142.19	142.22	142.055	142.12	2850596.0
2012-12-07 14:00:00	SPY	ETF	142.1199	142.25	142.05	142.21	6803188.0
2012-12-07 14:30:00	SPY	ETF	142.21	142.37	142.2	142.25	3602214.0
2012-12-07 15:00:00	SPY	ETF	142.2401	142.33	142.08	142.18	5235149.0
2012-12-07 15:30:00	SPY	ETF	142.19	142.45	142.17	142.4	13129245.0
2012-12-07 16:00:00	SPY	ETF	142.38	142.4794	142.0135	142.27	5328565.0
2012-12-07 16:30:00	SPY	ETF	142.28	142.41	142.25	142.38	4251278.0
2012-12-07 17:00:00	SPY	ETF	142.39	142.42	142.36	142.42	67073.0
2012-12-07 17:30:00	SPY	ETF	142.4	142.41	142.35	142.39	105427.0
2012-12-07 18:00:00	SPY	ETF	142.37	142.37	142.24	142.32	44283.0
2012-12-07 18:30:00	SPY	ETF	142.32	142.36	142.32	142.33	7092.0
2012-12-07 19:00:00	SPY	ETF	142.36	142.4	142.34	142.39	5747.0
2012-12-07 19:30:00	SPY	ETF	142.34	142.4	142.33	142.4	7652.0
2012-12-07 05:00:00	QQQ	ETF	65.21	65.22	65.21	65.22	2000.0
2012-12-07 07:00:00	QQQ	ETF	65.24	65.25	65.21	65.21	5100.0
2012-12-07 07:30:00	QQQ	ETF	65.21	65.22	65.18	65.19	3300.0
2012-12-07 08:00:00	QQQ	ETF	65.2	65.3	65.15	65.15	1036760.0
2012-12-07 08:30:00	QQQ	ETF	65.21	65.75	65.2	65.63	699890.0
2012-12-07 09:00:00	QQQ	ETF	65.63	65.66	65.28	65.64	82999.0
2012-12-07 09:30:00	QQQ	ETF	65.65	65.71	65.13	65.14	3715738.0
2012-12-07 10:00:00	QQQ	ETF	65.14	65.41	65.1	65.16	2468426.0
2012-12-07 10:30:00	QQQ	ETF	65.16	65.18	64.91	64.98	2966767.0
2012-12-07 11:00:00	QQQ	ETF	64.9801	65.05	64.81	64.96	3685022.0
2012-12-07 11:30:00	QQQ	ETF	64.95	65.01	64.74	64.76	1616328.0
2012-12-07 12:00:00	QQQ	ETF	64.76	64.94	64.73	64.831	1352760.0
2012-12-07 12:30:00	QQQ	ETF	64.83	64.88	64.71	64.86	963684.0
2012-12-07 13:00:00	QQQ	ETF	64.86	64.94	64.83	64.881	948804.0
2012-12-07 13:30:00	QQQ	ETF	64.883	64.9	64.77	64.85	633192.0
2012-12-07 14:00:00	QQQ	ETF	64.85	64.95	64.79	64.92	1683688.0
2012-12-07 14:30:00	QQQ	ETF	64.92	65.06	64.9	64.9401	1814766.0
2012-12-07 15:00:00	QQQ	ETF	64.9477	64.99	64.79	64.85	1285143.0

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

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