PREVIEW / etf_30min / 2012-02-06

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-06.parquet
  size:    288 KB
  rows:    9,772

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
2012-02-06 04:00:00	SPY	ETF	134.1	134.1	133.51	133.57	77827.0
2012-02-06 04:30:00	SPY	ETF	133.77	133.77	133.77	133.77	2700.0
2012-02-06 05:00:00	SPY	ETF	133.74	133.74	133.74	133.74	1200.0
2012-02-06 05:30:00	SPY	ETF	133.78	133.86	133.72	133.74	5501.0
2012-02-06 06:00:00	SPY	ETF	133.8	133.89	133.8	133.87	6050.0
2012-02-06 06:30:00	SPY	ETF	133.87	133.94	133.64	133.79	70265.0
2012-02-06 07:00:00	SPY	ETF	133.8	134.06	133.77	134.03	150015.0
2012-02-06 07:30:00	SPY	ETF	134.03	134.05	133.9	134.0	571319.0
2012-02-06 08:00:00	SPY	ETF	133.97	134.03	133.85	133.9	330076.0
2012-02-06 08:30:00	SPY	ETF	133.91	133.97	133.72	133.72	547491.0
2012-02-06 09:00:00	SPY	ETF	133.73	134.01	133.71	133.99	804005.0
2012-02-06 09:30:00	SPY	ETF	133.98	134.25	133.83	134.12	14805844.0
2012-02-06 10:00:00	SPY	ETF	134.11	134.31	134.07	134.08	7929235.0
2012-02-06 10:30:00	SPY	ETF	134.08	134.16	133.94	134.146	7119827.0
2012-02-06 11:00:00	SPY	ETF	134.145	134.34	134.09	134.27	7333723.0
2012-02-06 11:30:00	SPY	ETF	134.2664	134.33	134.18	134.31	4744296.0
2012-02-06 12:00:00	SPY	ETF	134.31	134.34	134.16	134.21	5913782.0
2012-02-06 12:30:00	SPY	ETF	134.21	134.41	134.18	134.36	5241120.0
2012-02-06 13:00:00	SPY	ETF	134.36	134.4	134.28	134.29	3423933.0
2012-02-06 13:30:00	SPY	ETF	134.28	134.36	134.11	134.19	3848332.0
2012-02-06 14:00:00	SPY	ETF	134.19	134.32	134.17	134.27	7888644.0
2012-02-06 14:30:00	SPY	ETF	134.27	134.36	134.23	134.2805	3479351.0
2012-02-06 15:00:00	SPY	ETF	134.28	134.42	134.28	134.34	5659745.0
2012-02-06 15:30:00	SPY	ETF	134.34	134.5	134.31	134.45	13811015.0
2012-02-06 16:00:00	SPY	ETF	134.44	134.57	134.19	134.36	10554552.0
2012-02-06 16:30:00	SPY	ETF	134.36	134.5	134.34	134.47	1237440.0
2012-02-06 17:00:00	SPY	ETF	134.47	134.51	134.46	134.49	183952.0
2012-02-06 17:30:00	SPY	ETF	134.48	134.51	134.43	134.45	37300.0
2012-02-06 18:00:00	SPY	ETF	134.46	134.54	134.46	134.49	92191.0
2012-02-06 18:30:00	SPY	ETF	134.49	134.51	134.46	134.48	12378.0
2012-02-06 19:00:00	SPY	ETF	134.48	134.51	134.4	134.51	37269.0
2012-02-06 19:30:00	SPY	ETF	134.5	134.54	134.5	134.5	35210.0
2012-02-06 04:00:00	QQQ	ETF	61.83	61.83	61.7	61.7	500.0
2012-02-06 05:30:00	QQQ	ETF	61.7	61.7	61.7	61.7	2000.0
2012-02-06 07:00:00	QQQ	ETF	61.75	61.85	61.75	61.84	5000.0
2012-02-06 07:30:00	QQQ	ETF	61.8	61.86	61.77	61.77	9614.0
2012-02-06 08:00:00	QQQ	ETF	61.87	61.87	61.72	61.75	136677.0
2012-02-06 08:30:00	QQQ	ETF	61.75	61.77	61.69	61.69	244161.0
2012-02-06 09:00:00	QQQ	ETF	61.69	61.83	61.67	61.81	151945.0
2012-02-06 09:30:00	QQQ	ETF	61.82	61.87	61.66	61.83	3391122.0
2012-02-06 10:00:00	QQQ	ETF	61.83	61.93	61.78	61.8	2235018.0
2012-02-06 10:30:00	QQQ	ETF	61.8	61.82	61.71	61.816	1941330.0
2012-02-06 11:00:00	QQQ	ETF	61.812	61.88	61.78	61.87	1852346.0
2012-02-06 11:30:00	QQQ	ETF	61.88	61.92	61.85	61.9	995730.0
2012-02-06 12:00:00	QQQ	ETF	61.9001	61.91	61.82	61.86	1293495.0
2012-02-06 12:30:00	QQQ	ETF	61.87	62.0	61.86	61.97	2898951.0
2012-02-06 13:00:00	QQQ	ETF	61.97	62.0	61.95	61.95	1283651.0
2012-02-06 13:30:00	QQQ	ETF	61.96	61.99	61.885	61.92	1898316.0
2012-02-06 14:00:00	QQQ	ETF	61.93	61.99	61.92	61.96	1377996.0
2012-02-06 14:30:00	QQQ	ETF	61.97	61.995	61.9	61.9	1354241.0

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

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