PREVIEW / etf_30min / 2011-11-15

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-11-15.parquet
  size:    278 KB
  rows:    9,320

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-11-15 04:00:00	SPY	ETF	125.48	125.48	124.76	125.0	8748.0
2011-11-15 04:30:00	SPY	ETF	125.15	125.17	124.92	125.02	2900.0
2011-11-15 05:00:00	SPY	ETF	125.05	125.22	125.03	125.17	11700.0
2011-11-15 05:30:00	SPY	ETF	124.88	124.88	124.64	124.65	35700.0
2011-11-15 06:00:00	SPY	ETF	124.67	124.7	124.21	124.43	183990.0
2011-11-15 06:30:00	SPY	ETF	124.19	124.32	123.97	124.32	410930.0
2011-11-15 07:00:00	SPY	ETF	124.2	124.64	124.15	124.51	399770.0
2011-11-15 07:30:00	SPY	ETF	124.51	124.69	124.34	124.36	364342.0
2011-11-15 08:00:00	SPY	ETF	124.65	124.84	124.16	124.77	2026373.0
2011-11-15 08:30:00	SPY	ETF	124.8	125.15	124.74	124.86	3491448.0
2011-11-15 09:00:00	SPY	ETF	124.85	125.19	124.83	125.18	1227966.0
2011-11-15 09:30:00	SPY	ETF	125.17	125.87	124.98	125.62	22469498.0
2011-11-15 10:00:00	SPY	ETF	125.63	125.68	125.09	125.349	15608588.0
2011-11-15 10:30:00	SPY	ETF	125.34	125.7	125.14	125.16	11689614.0
2011-11-15 11:00:00	SPY	ETF	125.16	125.42	124.82	124.99	11253949.0
2011-11-15 11:30:00	SPY	ETF	124.99	125.22	124.72	125.1	9975961.0
2011-11-15 12:00:00	SPY	ETF	125.11	125.72	125.1	125.64	10674546.0
2011-11-15 12:30:00	SPY	ETF	125.65	126.1	125.62	126.08	10896348.0
2011-11-15 13:00:00	SPY	ETF	126.075	126.29	125.96	126.15	8799372.0
2011-11-15 13:30:00	SPY	ETF	126.1416	126.5	126.14	126.34	10366260.0
2011-11-15 14:00:00	SPY	ETF	126.33	126.55	126.14	126.2	8297988.0
2011-11-15 14:30:00	SPY	ETF	126.2	126.5	126.18	126.41	6630145.0
2011-11-15 15:00:00	SPY	ETF	126.4	126.74	126.38	126.7	12237469.0
2011-11-15 15:30:00	SPY	ETF	126.705	126.75	126.05	126.12	21460009.0
2011-11-15 16:00:00	SPY	ETF	126.11	126.35	125.3222	125.98	9893697.0
2011-11-15 16:30:00	SPY	ETF	125.99	126.08	125.4874	126.03	4602360.0
2011-11-15 17:00:00	SPY	ETF	126.03	126.03	125.97	125.98	38605.0
2011-11-15 17:30:00	SPY	ETF	125.98	126.03	125.97	126.02	26297.0
2011-11-15 18:00:00	SPY	ETF	126.01	126.12	125.96	125.99	190743.0
2011-11-15 18:30:00	SPY	ETF	125.98	126.08	125.81	125.83	99507.0
2011-11-15 19:00:00	SPY	ETF	125.83	125.9	125.73	125.83	97970.0
2011-11-15 19:30:00	SPY	ETF	125.82	125.82	125.69	125.76	150410.0
2011-11-15 04:00:00	QQQ	ETF	57.28	57.28	57.26	57.26	300.0
2011-11-15 04:30:00	QQQ	ETF	57.22	57.22	57.22	57.22	500.0
2011-11-15 05:00:00	QQQ	ETF	57.27	57.36	57.27	57.36	3900.0
2011-11-15 05:30:00	QQQ	ETF	57.22	57.23	57.08	57.08	16000.0
2011-11-15 06:00:00	QQQ	ETF	57.01	57.01	56.88	56.88	2300.0
2011-11-15 06:30:00	QQQ	ETF	56.89	56.95	56.8	56.91	45864.0
2011-11-15 07:00:00	QQQ	ETF	56.91	57.07	56.91	57.03	12280.0
2011-11-15 07:30:00	QQQ	ETF	57.06	57.12	57.02	57.03	66966.0
2011-11-15 08:00:00	QQQ	ETF	57.03	57.21	57.03	57.15	81507.0
2011-11-15 08:30:00	QQQ	ETF	57.2	57.38	57.19	57.28	214344.0
2011-11-15 09:00:00	QQQ	ETF	57.29	57.52	57.27	57.34	81081.0
2011-11-15 09:30:00	QQQ	ETF	57.35	57.75	57.26	57.66	6903643.0
2011-11-15 10:00:00	QQQ	ETF	57.67	57.69	57.33	57.52	4793315.0
2011-11-15 10:30:00	QQQ	ETF	57.51	57.7	57.43	57.43	2576744.0
2011-11-15 11:00:00	QQQ	ETF	57.43	57.61	57.35	57.43	2586426.0
2011-11-15 11:30:00	QQQ	ETF	57.42	57.57	57.29	57.52	3058260.0
2011-11-15 12:00:00	QQQ	ETF	57.53	57.91	57.53	57.875	3178451.0
2011-11-15 12:30:00	QQQ	ETF	57.88	58.07	57.86	58.0381	3116366.0

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

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