PREVIEW / etf_30min / 2014-04-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-07.parquet
  size:    353 KB
  rows:    11,767

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
2014-04-07 04:00:00	SPY	ETF	185.99	185.99	185.66	185.86	42921.0
2014-04-07 04:30:00	SPY	ETF	185.86	185.86	185.71	185.71	13301.0
2014-04-07 05:00:00	SPY	ETF	185.75	186.04	185.74	186.03	13366.0
2014-04-07 05:30:00	SPY	ETF	185.98	186.01	185.83	185.83	40384.0
2014-04-07 06:00:00	SPY	ETF	185.83	185.96	185.75	185.76	81954.0
2014-04-07 06:30:00	SPY	ETF	185.77	185.86	185.74	185.84	22977.0
2014-04-07 07:00:00	SPY	ETF	185.86	185.91	185.55	185.65	213237.0
2014-04-07 07:30:00	SPY	ETF	185.69	185.82	185.6	185.76	202301.0
2014-04-07 08:00:00	SPY	ETF	185.75	185.88	185.57	185.8	426362.0
2014-04-07 08:30:00	SPY	ETF	185.78	186.05	185.76	185.94	983671.0
2014-04-07 09:00:00	SPY	ETF	185.96	186.02	185.84	185.91	667496.0
2014-04-07 09:30:00	SPY	ETF	185.9	186.05	185.22	186.0	16948483.0
2014-04-07 10:00:00	SPY	ETF	186.0	186.26	185.645	185.65	9940941.0
2014-04-07 10:30:00	SPY	ETF	185.64	185.87	185.17	185.33	9224493.0
2014-04-07 11:00:00	SPY	ETF	185.33	185.95	185.13	185.21	7108705.0
2014-04-07 11:30:00	SPY	ETF	185.21	185.45	184.78	184.79	8199779.0
2014-04-07 12:00:00	SPY	ETF	184.79	184.94	184.38	184.54	8849759.0
2014-04-07 12:30:00	SPY	ETF	184.54	184.83	184.46	184.76	8105217.0
2014-04-07 13:00:00	SPY	ETF	184.75	185.2814	184.2301	184.39	9122944.0
2014-04-07 13:30:00	SPY	ETF	184.39	184.45	184.14	184.215	6444480.0
2014-04-07 14:00:00	SPY	ETF	184.22	184.4	183.97	184.12	7634831.0
2014-04-07 14:30:00	SPY	ETF	184.11	184.86	183.96	184.69	10612742.0
2014-04-07 15:00:00	SPY	ETF	184.69	185.11	184.53	185.1	8898316.0
2014-04-07 15:30:00	SPY	ETF	185.1	185.1	184.3	184.31	16149568.0
2014-04-07 16:00:00	SPY	ETF	184.31	186.3177	184.26	184.34	5563972.0
2014-04-07 16:30:00	SPY	ETF	184.33	184.41	184.28	184.41	1008137.0
2014-04-07 17:00:00	SPY	ETF	184.41	184.48	184.41	184.48	94951.0
2014-04-07 17:30:00	SPY	ETF	184.47	184.48	184.45	184.48	49335.0
2014-04-07 18:00:00	SPY	ETF	184.49	184.55	184.48	184.55	48259.0
2014-04-07 18:30:00	SPY	ETF	184.55	184.61	184.55	184.6	32179.0
2014-04-07 19:00:00	SPY	ETF	184.61	184.63	184.6	184.63	24717.0
2014-04-07 19:30:00	SPY	ETF	184.63	184.63	184.59	184.59	32396.0
2014-04-07 04:00:00	QQQ	ETF	85.97	85.97	85.8	85.92	29184.0
2014-04-07 04:30:00	QQQ	ETF	85.87	85.87	85.84	85.84	5700.0
2014-04-07 05:00:00	QQQ	ETF	86.02	86.02	86.02	86.02	500.0
2014-04-07 05:30:00	QQQ	ETF	85.97	85.97	85.85	85.85	8150.0
2014-04-07 06:00:00	QQQ	ETF	85.85	85.88	85.83	85.83	25600.0
2014-04-07 06:30:00	QQQ	ETF	85.85	85.91	85.81	85.9	9970.0
2014-04-07 07:00:00	QQQ	ETF	85.9	85.9	85.71	85.78	56452.0
2014-04-07 07:30:00	QQQ	ETF	85.79	85.82	85.74	85.8	291265.0
2014-04-07 08:00:00	QQQ	ETF	85.79	85.93	85.55	85.77	1556484.0
2014-04-07 08:30:00	QQQ	ETF	85.77	85.93	85.76	85.83	1703666.0
2014-04-07 09:00:00	QQQ	ETF	85.85	85.89	85.76	85.86	651976.0
2014-04-07 09:30:00	QQQ	ETF	85.84	86.34	85.55	86.34	14171289.0
2014-04-07 10:00:00	QQQ	ETF	86.335	86.63	86.12	86.12	11514241.0
2014-04-07 10:30:00	QQQ	ETF	86.12	86.36	85.82	86.0	5031331.0
2014-04-07 11:00:00	QQQ	ETF	86.0	86.25	85.91	85.99	3153191.0
2014-04-07 11:30:00	QQQ	ETF	85.98	86.19	85.61	85.63	2624421.0
2014-04-07 12:00:00	QQQ	ETF	85.62	85.791	85.33	85.51	4122703.0
2014-04-07 12:30:00	QQQ	ETF	85.5	85.68	85.4	85.62	2299778.0

> showing 50 of 11,767 rows — these rows as CSV

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