PREVIEW / etf_30min / 2013-08-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-08-12.parquet
  size:    311 KB
  rows:    10,696

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-08-12 04:00:00	SPY	ETF	169.0	169.0	168.27	168.35	26807.0
2013-08-12 04:30:00	SPY	ETF	168.33	168.41	168.3	168.35	14570.0
2013-08-12 05:00:00	SPY	ETF	168.32	168.32	168.0	168.1	46900.0
2013-08-12 05:30:00	SPY	ETF	168.05	168.18	168.04	168.18	24900.0
2013-08-12 06:00:00	SPY	ETF	168.2	168.25	168.2	168.2	2800.0
2013-08-12 06:30:00	SPY	ETF	168.25	168.29	168.22	168.27	43279.0
2013-08-12 07:00:00	SPY	ETF	168.29	168.46	168.27	168.43	225288.0
2013-08-12 07:30:00	SPY	ETF	168.41	168.47	168.36	168.37	103434.0
2013-08-12 08:00:00	SPY	ETF	168.29	168.47	168.29	168.32	229439.0
2013-08-12 08:30:00	SPY	ETF	168.36	168.58	168.3	168.54	1074645.0
2013-08-12 09:00:00	SPY	ETF	168.54	168.57	168.37	168.46	1290778.0
2013-08-12 09:30:00	SPY	ETF	168.46	169.05	168.38	168.9	11295330.0
2013-08-12 10:00:00	SPY	ETF	168.9	169.18	168.89	168.94	9034556.0
2013-08-12 10:30:00	SPY	ETF	168.95	169.28	168.92	169.248	4164073.0
2013-08-12 11:00:00	SPY	ETF	169.24	169.31	169.06	169.23	4372661.0
2013-08-12 11:30:00	SPY	ETF	169.24	169.31	169.03	169.12	3260584.0
2013-08-12 12:00:00	SPY	ETF	169.118	169.13	168.91	168.93	2332869.0
2013-08-12 12:30:00	SPY	ETF	168.93	169.08	168.8	169.0699	5534143.0
2013-08-12 13:00:00	SPY	ETF	169.061	169.13	168.83	168.97	2212128.0
2013-08-12 13:30:00	SPY	ETF	168.98	169.09	168.76	168.84	2291333.0
2013-08-12 14:00:00	SPY	ETF	168.8301	168.93	168.79	168.87	1867080.0
2013-08-12 14:30:00	SPY	ETF	168.865	169.0	168.8	169.0	2667902.0
2013-08-12 15:00:00	SPY	ETF	168.995	169.15	168.89	169.06	3781972.0
2013-08-12 15:30:00	SPY	ETF	169.06	169.24	169.04	169.11	6472693.0
2013-08-12 16:00:00	SPY	ETF	169.1	169.2995	168.3393	169.15	4558607.0
2013-08-12 16:30:00	SPY	ETF	169.16	169.28	168.9082	169.28	460022.0
2013-08-12 17:00:00	SPY	ETF	169.28	169.33	169.27	169.32	48019.0
2013-08-12 17:30:00	SPY	ETF	169.32	169.33	169.28	169.3	181499.0
2013-08-12 18:00:00	SPY	ETF	169.31	169.31	169.25	169.29	30445.0
2013-08-12 18:30:00	SPY	ETF	169.25	169.28	169.25	169.26	13160.0
2013-08-12 19:00:00	SPY	ETF	169.26	169.26	169.23	169.25	14762.0
2013-08-12 19:30:00	SPY	ETF	169.25	169.26	169.18	169.23	57196.0
2013-08-12 04:00:00	QQQ	ETF	76.44	76.44	76.1	76.1	24720.0
2013-08-12 04:30:00	QQQ	ETF	76.09	76.11	76.09	76.11	200.0
2013-08-12 05:00:00	QQQ	ETF	76.09	76.09	75.97	75.97	8800.0
2013-08-12 05:30:00	QQQ	ETF	75.99	76.02	75.99	76.02	2500.0
2013-08-12 06:00:00	QQQ	ETF	76.03	76.05	76.03	76.05	2700.0
2013-08-12 06:30:00	QQQ	ETF	76.06	76.09	76.06	76.09	4000.0
2013-08-12 07:00:00	QQQ	ETF	76.1	76.19	76.1	76.19	8200.0
2013-08-12 07:30:00	QQQ	ETF	76.19	76.19	76.17	76.17	9210.0
2013-08-12 08:00:00	QQQ	ETF	76.17	76.23	76.11	76.18	18716.0
2013-08-12 08:30:00	QQQ	ETF	76.18	76.26	76.16	76.26	23950.0
2013-08-12 09:00:00	QQQ	ETF	76.25	76.28	76.17	76.19	87928.0
2013-08-12 09:30:00	QQQ	ETF	76.2	76.59	76.19	76.54	2359517.0
2013-08-12 10:00:00	QQQ	ETF	76.54	76.72	76.54	76.56	1629068.0
2013-08-12 10:30:00	QQQ	ETF	76.57	76.78	76.5638	76.77	1500417.0
2013-08-12 11:00:00	QQQ	ETF	76.77	76.8099	76.66	76.72	1158814.0
2013-08-12 11:30:00	QQQ	ETF	76.72	76.765	76.64	76.68	557036.0
2013-08-12 12:00:00	QQQ	ETF	76.68	76.69	76.535	76.5501	700519.0
2013-08-12 12:30:00	QQQ	ETF	76.54	76.67	76.5	76.65	783410.0

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

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