PREVIEW / etf_30min / 2013-11-06

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-06.parquet
  size:    310 KB
  rows:    10,967

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-06 04:00:00	SPY	ETF	176.75	176.95	176.75	176.89	62081.0
2013-11-06 04:30:00	SPY	ETF	176.94	177.01	176.93	176.98	201187.0
2013-11-06 05:00:00	SPY	ETF	176.98	177.06	176.93	177.06	231659.0
2013-11-06 05:30:00	SPY	ETF	177.05	177.17	177.03	177.12	281832.0
2013-11-06 06:00:00	SPY	ETF	177.16	177.2	177.09	177.16	42271.0
2013-11-06 06:30:00	SPY	ETF	177.18	177.19	177.0	177.0	32702.0
2013-11-06 07:00:00	SPY	ETF	177.03	177.1	176.93	177.09	179298.0
2013-11-06 07:30:00	SPY	ETF	177.09	177.12	177.01	177.01	46295.0
2013-11-06 08:00:00	SPY	ETF	177.0	177.07	176.91	176.99	249437.0
2013-11-06 08:30:00	SPY	ETF	176.99	177.02	176.9	176.93	394225.0
2013-11-06 09:00:00	SPY	ETF	176.94	177.07	176.92	177.04	546244.0
2013-11-06 09:30:00	SPY	ETF	177.03	177.5	176.88	177.34	12144405.0
2013-11-06 10:00:00	SPY	ETF	177.345	177.48	177.01	177.02	6511963.0
2013-11-06 10:30:00	SPY	ETF	177.01	177.05	176.7	176.84	6176743.0
2013-11-06 11:00:00	SPY	ETF	176.83	176.92	176.54	176.9	5499363.0
2013-11-06 11:30:00	SPY	ETF	176.9	176.99	176.75	176.79	4867566.0
2013-11-06 12:00:00	SPY	ETF	176.79	176.99	176.77	176.96	2472136.0
2013-11-06 12:30:00	SPY	ETF	176.965	177.11	176.92	176.94	2634909.0
2013-11-06 13:00:00	SPY	ETF	176.93	177.14	176.88	177.1	3263324.0
2013-11-06 13:30:00	SPY	ETF	177.11	177.17	177.0	177.03	2807153.0
2013-11-06 14:00:00	SPY	ETF	177.025	177.09	176.88	176.94	4827331.0
2013-11-06 14:30:00	SPY	ETF	176.93	177.1	176.93	177.04	2102150.0
2013-11-06 15:00:00	SPY	ETF	177.05	177.18	176.97	177.03	4249080.0
2013-11-06 15:30:00	SPY	ETF	177.03	177.24	176.88	177.15	15278310.0
2013-11-06 16:00:00	SPY	ETF	177.15	177.3473	176.4116	177.06	6026795.0
2013-11-06 16:30:00	SPY	ETF	177.06	177.17	177.02	177.02	4135732.0
2013-11-06 17:00:00	SPY	ETF	177.03	177.03	176.9	176.91	663291.0
2013-11-06 17:30:00	SPY	ETF	176.91	176.95	176.88	176.93	52142.0
2013-11-06 18:00:00	SPY	ETF	176.92	176.92	176.77	176.78	101364.0
2013-11-06 18:30:00	SPY	ETF	176.78	176.81	176.7	176.76	68082.0
2013-11-06 19:00:00	SPY	ETF	176.76	176.79	176.71	176.77	24054.0
2013-11-06 19:30:00	SPY	ETF	176.75	176.82	176.73	176.82	25033.0
2013-11-06 04:00:00	QQQ	ETF	83.3	83.3	83.24	83.24	3200.0
2013-11-06 05:30:00	QQQ	ETF	83.3	83.32	83.3	83.32	11399.0
2013-11-06 06:00:00	QQQ	ETF	83.31	83.32	83.31	83.32	1040.0
2013-11-06 07:00:00	QQQ	ETF	83.26	83.3	83.26	83.3	9800.0
2013-11-06 07:30:00	QQQ	ETF	83.32	83.32	83.27	83.27	25950.0
2013-11-06 08:00:00	QQQ	ETF	83.26	83.29	83.23	83.26	71000.0
2013-11-06 08:30:00	QQQ	ETF	83.24	83.24	83.21	83.21	21915.0
2013-11-06 09:00:00	QQQ	ETF	83.21	83.38	83.2	83.34	67014.0
2013-11-06 09:30:00	QQQ	ETF	83.35	83.4	83.1	83.31	4269912.0
2013-11-06 10:00:00	QQQ	ETF	83.32	83.365	83.04	83.05	2988912.0
2013-11-06 10:30:00	QQQ	ETF	83.045	83.1	82.84	82.9	2634064.0
2013-11-06 11:00:00	QQQ	ETF	82.9	82.999	82.73	82.96	2170373.0
2013-11-06 11:30:00	QQQ	ETF	82.96	83.03	82.84	82.92	1636598.0
2013-11-06 12:00:00	QQQ	ETF	82.91	83.01	82.9	82.93	855217.0
2013-11-06 12:30:00	QQQ	ETF	82.929	82.9899	82.83	82.84	1566029.0
2013-11-06 13:00:00	QQQ	ETF	82.83	83.0	82.79	82.97	950286.0
2013-11-06 13:30:00	QQQ	ETF	82.97	83.01	82.86	82.89	554212.0
2013-11-06 14:00:00	QQQ	ETF	82.88	82.93	82.84	82.88	947730.0

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

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