PREVIEW / etf_30min / 2013-11-05

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-05.parquet
  size:    315 KB
  rows:    10,886

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
2013-11-05 04:00:00	SPY	ETF	176.66	176.66	176.54	176.56	13339.0
2013-11-05 04:30:00	SPY	ETF	176.55	176.55	176.26	176.3	34281.0
2013-11-05 05:00:00	SPY	ETF	176.33	176.41	176.29	176.4	13034.0
2013-11-05 05:30:00	SPY	ETF	176.39	176.39	176.3	176.33	1907.0
2013-11-05 06:00:00	SPY	ETF	176.35	176.43	176.33	176.41	46300.0
2013-11-05 06:30:00	SPY	ETF	176.4	176.45	176.26	176.29	41000.0
2013-11-05 07:00:00	SPY	ETF	176.33	176.38	176.21	176.26	274347.0
2013-11-05 07:30:00	SPY	ETF	176.3	176.37	176.24	176.33	154834.0
2013-11-05 08:00:00	SPY	ETF	176.33	176.4	176.24	176.37	241228.0
2013-11-05 08:30:00	SPY	ETF	176.37	176.37	176.07	176.11	982288.0
2013-11-05 09:00:00	SPY	ETF	176.11	176.2	176.04	176.11	486306.0
2013-11-05 09:30:00	SPY	ETF	176.14	176.23	175.67	175.801	12382880.0
2013-11-05 10:00:00	SPY	ETF	175.8	175.99	175.57	175.92	10407395.0
2013-11-05 10:30:00	SPY	ETF	175.92	176.425	175.92	176.33	9302753.0
2013-11-05 11:00:00	SPY	ETF	176.335	176.5	176.211	176.25	4707509.0
2013-11-05 11:30:00	SPY	ETF	176.25	176.5	176.24	176.45	4709137.0
2013-11-05 12:00:00	SPY	ETF	176.46	176.75	176.4	176.68	3670056.0
2013-11-05 12:30:00	SPY	ETF	176.68	176.7093	176.52	176.56	3579273.0
2013-11-05 13:00:00	SPY	ETF	176.56	176.69	176.56	176.64	1820658.0
2013-11-05 13:30:00	SPY	ETF	176.64	176.6999	176.36	176.3701	2749230.0
2013-11-05 14:00:00	SPY	ETF	176.371	176.631	176.35	176.57	2768531.0
2013-11-05 14:30:00	SPY	ETF	176.58	176.72	176.55	176.59	2994540.0
2013-11-05 15:00:00	SPY	ETF	176.58	176.72	176.41	176.46	3774621.0
2013-11-05 15:30:00	SPY	ETF	176.455	176.59	176.25	176.32	11940417.0
2013-11-05 16:00:00	SPY	ETF	176.31	176.42	176.16	176.21	4649579.0
2013-11-05 16:30:00	SPY	ETF	176.2	176.3183	176.14	176.24	899028.0
2013-11-05 17:00:00	SPY	ETF	176.23	176.26	176.18	176.18	1751293.0
2013-11-05 17:30:00	SPY	ETF	176.23	176.29	176.23	176.25	224023.0
2013-11-05 18:00:00	SPY	ETF	176.25	176.26	176.12	176.16	64958.0
2013-11-05 18:30:00	SPY	ETF	176.17	176.22	176.16	176.2	15180.0
2013-11-05 19:00:00	SPY	ETF	176.18	176.39	176.18	176.39	84305.0
2013-11-05 19:30:00	SPY	ETF	176.39	176.44	176.34	176.37	60210.0
2013-11-05 04:00:00	QQQ	ETF	82.86	82.86	82.8	82.8	5600.0
2013-11-05 04:30:00	QQQ	ETF	82.77	82.77	82.62	82.62	9300.0
2013-11-05 05:00:00	QQQ	ETF	82.64	82.64	82.64	82.64	1400.0
2013-11-05 05:30:00	QQQ	ETF	82.62	82.62	82.62	82.62	1400.0
2013-11-05 06:00:00	QQQ	ETF	82.64	82.64	82.64	82.64	1400.0
2013-11-05 06:30:00	QQQ	ETF	82.67	82.67	82.62	82.64	6000.0
2013-11-05 07:00:00	QQQ	ETF	82.66	82.67	82.6	82.61	61000.0
2013-11-05 07:30:00	QQQ	ETF	82.64	82.66	82.62	82.66	59200.0
2013-11-05 08:00:00	QQQ	ETF	82.65	82.7	82.62	82.7	22800.0
2013-11-05 08:30:00	QQQ	ETF	82.68	82.69	82.56	82.57	66900.0
2013-11-05 09:00:00	QQQ	ETF	82.58	82.64	82.56	82.59	108113.0
2013-11-05 09:30:00	QQQ	ETF	82.59	82.74	82.45	82.53	4683295.0
2013-11-05 10:00:00	QQQ	ETF	82.53	82.66	82.37	82.59	3253487.0
2013-11-05 10:30:00	QQQ	ETF	82.59	82.91	82.59	82.87	3013734.0
2013-11-05 11:00:00	QQQ	ETF	82.88	82.96	82.83	82.84	2174293.0
2013-11-05 11:30:00	QQQ	ETF	82.85	82.94	82.83	82.91	1176399.0
2013-11-05 12:00:00	QQQ	ETF	82.9	83.05	82.87	83.01	1153666.0
2013-11-05 12:30:00	QQQ	ETF	83.02	83.08	82.97	83.0137	774171.0

> showing 50 of 10,886 rows — these rows as CSV

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