PREVIEW / etf_30min / 2010-06-09

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-06-09.parquet
  size:    259 KB
  rows:    8,423

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
2010-06-09 04:00:00	SPY	ETF	106.39	106.41	106.31	106.33	2300.0
2010-06-09 04:30:00	SPY	ETF	106.26	106.32	106.21	106.23	450.0
2010-06-09 05:00:00	SPY	ETF	106.2	106.28	106.01	106.01	4400.0
2010-06-09 05:30:00	SPY	ETF	105.98	106.22	105.98	106.22	17200.0
2010-06-09 06:00:00	SPY	ETF	106.19	106.48	106.16	106.48	16800.0
2010-06-09 06:30:00	SPY	ETF	106.4	106.67	106.4	106.64	27950.0
2010-06-09 07:00:00	SPY	ETF	106.57	106.78	106.55	106.74	494705.0
2010-06-09 07:30:00	SPY	ETF	106.74	107.1	106.73	107.07	960954.0
2010-06-09 08:00:00	SPY	ETF	107.07	107.22	106.59	107.1	5590150.0
2010-06-09 08:30:00	SPY	ETF	107.1	107.27	105.9	107.1	1713518.0
2010-06-09 09:00:00	SPY	ETF	107.1	107.31	107.09	107.25	2245765.0
2010-06-09 09:30:00	SPY	ETF	107.24	107.42	106.95	107.19	31542642.0
2010-06-09 10:00:00	SPY	ETF	107.19	107.33	106.83	107.2	19062294.0
2010-06-09 10:30:00	SPY	ETF	107.2	107.55	106.88	107.541	17071779.0
2010-06-09 11:00:00	SPY	ETF	107.54	108.28	107.4601	108.18	19993926.0
2010-06-09 11:30:00	SPY	ETF	108.18	108.21	107.95	108.01	11635393.0
2010-06-09 12:00:00	SPY	ETF	108.01	108.15	107.86	108.02	7116275.0
2010-06-09 12:30:00	SPY	ETF	108.0199	108.07	107.77	107.77	6842439.0
2010-06-09 13:00:00	SPY	ETF	107.7774	107.91	107.66	107.71	7491622.0
2010-06-09 13:30:00	SPY	ETF	107.71	108.2	107.41	107.62	10287279.0
2010-06-09 14:00:00	SPY	ETF	107.6217	107.72	107.16	107.58	15241420.0
2010-06-09 14:30:00	SPY	ETF	107.585	107.65	106.63	106.66	17407107.0
2010-06-09 15:00:00	SPY	ETF	106.65	106.9667	105.6	106.48	33888452.0
2010-06-09 15:30:00	SPY	ETF	106.48	106.5	105.66	106.01	39327651.0
2010-06-09 16:00:00	SPY	ETF	106.02	108.2	105.95	106.04	8405958.0
2010-06-09 16:30:00	SPY	ETF	106.03	106.6727	105.91	105.99	1632571.0
2010-06-09 17:00:00	SPY	ETF	105.99	106.01	105.8	105.8	1313325.0
2010-06-09 17:30:00	SPY	ETF	105.83	105.85	105.75	105.85	64976.0
2010-06-09 18:00:00	SPY	ETF	105.8	105.99	105.71	105.97	142830.0
2010-06-09 18:30:00	SPY	ETF	105.97	106.0	105.91	105.94	31508.0
2010-06-09 19:00:00	SPY	ETF	105.98	106.0	105.88	105.9	22978.0
2010-06-09 19:30:00	SPY	ETF	105.85	106.01	105.8	106.0	71232.0
2010-06-09 04:00:00	QQQ	ETF	44.14	44.14	44.14	44.14	3100.0
2010-06-09 05:30:00	QQQ	ETF	43.94	43.94	43.94	43.94	200.0
2010-06-09 06:00:00	QQQ	ETF	44.03	44.04	44.03	44.04	2200.0
2010-06-09 06:30:00	QQQ	ETF	44.15	44.15	44.15	44.15	800.0
2010-06-09 07:00:00	QQQ	ETF	44.2	44.26	44.17	44.22	31273.0
2010-06-09 07:30:00	QQQ	ETF	44.24	44.38	44.24	44.35	143516.0
2010-06-09 08:00:00	QQQ	ETF	44.36	44.44	44.19	44.41	3890180.0
2010-06-09 08:30:00	QQQ	ETF	44.41	44.54	44.41	44.44	812430.0
2010-06-09 09:00:00	QQQ	ETF	44.44	44.52	44.19	44.48	329952.0
2010-06-09 09:30:00	QQQ	ETF	44.48	44.56	44.32	44.4199	11865499.0
2010-06-09 10:00:00	QQQ	ETF	44.41	44.47	44.18	44.33	7681495.0
2010-06-09 10:30:00	QQQ	ETF	44.33	44.55	44.2	44.55	7357370.0
2010-06-09 11:00:00	QQQ	ETF	44.55	44.91	44.53	44.88	6576530.0
2010-06-09 11:30:00	QQQ	ETF	44.87	44.89	44.72	44.75	4185540.0
2010-06-09 12:00:00	QQQ	ETF	44.76	44.89	44.7	44.81	2319558.0
2010-06-09 12:30:00	QQQ	ETF	44.82	44.83	44.66	44.6699	2882641.0
2010-06-09 13:00:00	QQQ	ETF	44.67	44.73	44.62	44.63	4082973.0
2010-06-09 13:30:00	QQQ	ETF	44.64	44.7	44.48	44.58	4258227.0

> showing 50 of 8,423 rows — these rows as CSV

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