PREVIEW / etf_30min / 2013-11-07

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-11-07.parquet
  size:    338 KB
  rows:    11,267

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-07 04:00:00	SPY	ETF	176.93	176.93	176.8	176.8	40800.0
2013-11-07 04:30:00	SPY	ETF	176.8	176.89	176.77	176.88	2027.0
2013-11-07 05:00:00	SPY	ETF	176.85	176.93	176.85	176.9	9611.0
2013-11-07 05:30:00	SPY	ETF	176.9	176.9	176.79	176.79	28461.0
2013-11-07 06:00:00	SPY	ETF	176.79	176.83	176.78	176.83	21708.0
2013-11-07 06:30:00	SPY	ETF	176.8	176.83	176.75	176.83	2049.0
2013-11-07 07:00:00	SPY	ETF	176.81	177.03	176.8	176.98	76050.0
2013-11-07 07:30:00	SPY	ETF	176.99	177.93	176.95	177.72	1175745.0
2013-11-07 08:00:00	SPY	ETF	177.7	177.95	176.98	177.72	647708.0
2013-11-07 08:30:00	SPY	ETF	177.72	177.87	177.48	177.64	1666662.0
2013-11-07 09:00:00	SPY	ETF	177.64	177.68	177.48	177.49	712425.0
2013-11-07 09:30:00	SPY	ETF	177.5	177.64	177.11	177.17	11036055.0
2013-11-07 10:00:00	SPY	ETF	177.16	177.25	176.38	176.65	13596792.0
2013-11-07 10:30:00	SPY	ETF	176.65	176.66	176.15	176.2972	14062998.0
2013-11-07 11:00:00	SPY	ETF	176.29	176.46	175.72	175.98	10595500.0
2013-11-07 11:30:00	SPY	ETF	175.98	176.4	175.89	176.39	7163159.0
2013-11-07 12:00:00	SPY	ETF	176.39	176.66	176.36	176.49	5202516.0
2013-11-07 12:30:00	SPY	ETF	176.5	176.58	176.21	176.22	3644952.0
2013-11-07 13:00:00	SPY	ETF	176.23	176.3	175.78	175.83	3894334.0
2013-11-07 13:30:00	SPY	ETF	175.82	175.92	175.6	175.69	7429475.0
2013-11-07 14:00:00	SPY	ETF	175.69	175.7	175.22	175.31	10369035.0
2013-11-07 14:30:00	SPY	ETF	175.3	175.63	175.05	175.53	11206088.0
2013-11-07 15:00:00	SPY	ETF	175.535	175.59	174.91	174.93	9060608.0
2013-11-07 15:30:00	SPY	ETF	174.94	175.12	174.76	174.94	25378638.0
2013-11-07 16:00:00	SPY	ETF	174.95	177.2009	174.8712	175.07	8624705.0
2013-11-07 16:30:00	SPY	ETF	175.08	177.2009	175.03	175.05	1383054.0
2013-11-07 17:00:00	SPY	ETF	175.05	175.08	174.9	174.95	7233923.0
2013-11-07 17:30:00	SPY	ETF	174.93	174.98	174.92	174.98	24262.0
2013-11-07 18:00:00	SPY	ETF	174.99	175.08	174.86	174.9	124660.0
2013-11-07 18:30:00	SPY	ETF	174.9	175.08	174.9	175.06	29244.0
2013-11-07 19:00:00	SPY	ETF	175.08	175.33	175.06	175.33	289368.0
2013-11-07 19:30:00	SPY	ETF	175.32	175.34	175.19	175.25	355120.0
2013-11-07 04:00:00	QQQ	ETF	82.83	82.83	82.8	82.8	7400.0
2013-11-07 04:30:00	QQQ	ETF	82.76	82.77	82.76	82.77	5000.0
2013-11-07 05:00:00	QQQ	ETF	82.78	82.82	82.78	82.8	4100.0
2013-11-07 05:30:00	QQQ	ETF	82.79	82.79	82.75	82.75	5300.0
2013-11-07 07:00:00	QQQ	ETF	82.75	82.85	82.75	82.85	7415.0
2013-11-07 07:30:00	QQQ	ETF	82.86	83.11	82.83	83.06	182410.0
2013-11-07 08:00:00	QQQ	ETF	83.05	83.14	82.76	83.08	664480.0
2013-11-07 08:30:00	QQQ	ETF	83.08	83.11	82.98	83.0	177657.0
2013-11-07 09:00:00	QQQ	ETF	83.01	83.03	82.95	82.97	62986.0
2013-11-07 09:30:00	QQQ	ETF	82.98	83.13	82.67	82.71	4159034.0
2013-11-07 10:00:00	QQQ	ETF	82.7	82.77	82.06	82.241	8301239.0
2013-11-07 10:30:00	QQQ	ETF	82.24	82.29	81.97	82.14	5130531.0
2013-11-07 11:00:00	QQQ	ETF	82.15	82.24	81.83	81.93	3606884.0
2013-11-07 11:30:00	QQQ	ETF	81.93	82.1256	81.88	82.1256	2070414.0
2013-11-07 12:00:00	QQQ	ETF	82.13	82.28	82.1	82.2	1782631.0
2013-11-07 12:30:00	QQQ	ETF	82.2	82.26	82.08	82.08	1378484.0
2013-11-07 13:00:00	QQQ	ETF	82.08	82.15	81.84	81.87	1396989.0
2013-11-07 13:30:00	QQQ	ETF	81.87	81.96	81.82	81.89	1679231.0

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

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