PREVIEW / etf_30min / 2011-10-11

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-10-11.parquet
  size:    276 KB
  rows:    9,310

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-11 04:00:00	SPY	ETF	119.19	119.19	118.95	119.07	6580.0
2011-10-11 04:30:00	SPY	ETF	118.98	118.99	118.71	118.84	34850.0
2011-10-11 05:00:00	SPY	ETF	118.89	118.94	118.79	118.94	5550.0
2011-10-11 05:30:00	SPY	ETF	118.82	119.03	118.77	118.97	20699.0
2011-10-11 06:00:00	SPY	ETF	119.06	119.25	118.88	118.96	48475.0
2011-10-11 06:30:00	SPY	ETF	118.9	119.12	118.77	119.12	24588.0
2011-10-11 07:00:00	SPY	ETF	119.14	119.25	119.06	119.21	151743.0
2011-10-11 07:30:00	SPY	ETF	119.25	119.45	118.98	119.02	483125.0
2011-10-11 08:00:00	SPY	ETF	119.02	119.23	118.74	118.94	1868740.0
2011-10-11 08:30:00	SPY	ETF	118.94	118.96	118.62	118.88	2054111.0
2011-10-11 09:00:00	SPY	ETF	118.88	118.94	118.65	118.87	3302692.0
2011-10-11 09:30:00	SPY	ETF	118.87	119.41	118.75	119.19	23910646.0
2011-10-11 10:00:00	SPY	ETF	119.18	119.66	118.91	119.66	19981596.0
2011-10-11 10:30:00	SPY	ETF	119.66	120.04	119.54	119.66	19694623.0
2011-10-11 11:00:00	SPY	ETF	119.67	119.77	119.31	119.42	12477689.0
2011-10-11 11:30:00	SPY	ETF	119.43	119.89	119.2922	119.81	11527401.0
2011-10-11 12:00:00	SPY	ETF	119.81	119.96	119.64	119.75	7427479.0
2011-10-11 12:30:00	SPY	ETF	119.75	119.8	119.23	119.52	8695421.0
2011-10-11 13:00:00	SPY	ETF	119.52	119.71	119.16	119.66	9266248.0
2011-10-11 13:30:00	SPY	ETF	119.66	119.9	119.39	119.89	10392178.0
2011-10-11 14:00:00	SPY	ETF	119.89	119.92	119.36	119.43	9795427.0
2011-10-11 14:30:00	SPY	ETF	119.42	119.6	119.23	119.51	9545264.0
2011-10-11 15:00:00	SPY	ETF	119.51	119.9	119.43	119.46	14830219.0
2011-10-11 15:30:00	SPY	ETF	119.46	119.93	119.44	119.65	26321316.0
2011-10-11 16:00:00	SPY	ETF	119.64	119.8	119.1649	119.35	7936733.0
2011-10-11 16:30:00	SPY	ETF	119.35	119.35	119.1	119.15	5840353.0
2011-10-11 17:00:00	SPY	ETF	119.15	119.34	119.06	119.27	396013.0
2011-10-11 17:30:00	SPY	ETF	119.27	119.34	119.09	119.21	1297502.0
2011-10-11 18:00:00	SPY	ETF	119.21	119.68	119.11	119.16	173175.0
2011-10-11 18:30:00	SPY	ETF	119.16	119.2	119.13	119.16	18253.0
2011-10-11 19:00:00	SPY	ETF	119.14	119.24	119.13	119.14	37848.0
2011-10-11 19:30:00	SPY	ETF	119.15	119.19	119.05	119.1	85130.0
2011-10-11 04:30:00	QQQ	ETF	55.75	55.75	55.69	55.73	4406.0
2011-10-11 06:00:00	QQQ	ETF	55.87	55.89	55.73	55.73	13000.0
2011-10-11 06:30:00	QQQ	ETF	55.66	55.66	55.66	55.66	5000.0
2011-10-11 07:00:00	QQQ	ETF	55.85	55.89	55.8	55.89	10173.0
2011-10-11 07:30:00	QQQ	ETF	55.89	55.97	55.8	55.8	116482.0
2011-10-11 08:00:00	QQQ	ETF	55.84	55.94	55.79	55.85	108898.0
2011-10-11 08:30:00	QQQ	ETF	55.82	55.84	55.68	55.79	332790.0
2011-10-11 09:00:00	QQQ	ETF	55.81	55.82	55.73	55.79	163320.0
2011-10-11 09:30:00	QQQ	ETF	55.8	56.09	55.7	55.98	7429606.0
2011-10-11 10:00:00	QQQ	ETF	55.98	56.3	55.85	56.2902	6496716.0
2011-10-11 10:30:00	QQQ	ETF	56.29	56.46	56.23	56.28	6699359.0
2011-10-11 11:00:00	QQQ	ETF	56.28	56.32	56.16	56.22	3270832.0
2011-10-11 11:30:00	QQQ	ETF	56.22	56.42	56.22	56.35	3550996.0
2011-10-11 12:00:00	QQQ	ETF	56.356	56.42	56.2701	56.34	1941796.0
2011-10-11 12:30:00	QQQ	ETF	56.34	56.365	56.095	56.22	2205788.0
2011-10-11 13:00:00	QQQ	ETF	56.22	56.28	56.06	56.2484	2578282.0
2011-10-11 13:30:00	QQQ	ETF	56.25	56.43	56.18	56.42	4996836.0
2011-10-11 14:00:00	QQQ	ETF	56.41	56.44	56.16	56.19	4714317.0

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

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