PREVIEW / etf_30min / 2011-02-01

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-02-01.parquet
  size:    286 KB
  rows:    9,460

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
2011-02-01 04:00:00	SPY	ETF	128.89	128.98	128.89	128.98	200.0
2011-02-01 04:30:00	SPY	ETF	129.01	129.05	129.01	129.05	700.0
2011-02-01 05:00:00	SPY	ETF	129.17	129.2	129.17	129.2	20700.0
2011-02-01 05:30:00	SPY	ETF	129.2	129.26	129.2	129.25	17500.0
2011-02-01 06:00:00	SPY	ETF	129.25	129.3	129.25	129.27	5600.0
2011-02-01 06:30:00	SPY	ETF	129.29	129.34	129.27	129.29	317100.0
2011-02-01 07:00:00	SPY	ETF	129.28	129.32	129.2	129.23	330325.0
2011-02-01 07:30:00	SPY	ETF	129.24	129.39	129.13	129.35	217601.0
2011-02-01 08:00:00	SPY	ETF	129.33	129.5	129.15	129.42	1018840.0
2011-02-01 08:30:00	SPY	ETF	129.42	129.44	128.67	129.4	516302.0
2011-02-01 09:00:00	SPY	ETF	129.41	129.53	128.67	129.46	1042435.0
2011-02-01 09:30:00	SPY	ETF	129.46	129.88	129.3801	129.87	19452622.0
2011-02-01 10:00:00	SPY	ETF	129.87	130.14	129.69	130.03	17264992.0
2011-02-01 10:30:00	SPY	ETF	130.03	130.28	129.97	130.2462	11670379.0
2011-02-01 11:00:00	SPY	ETF	130.25	130.35	130.09	130.15	8255588.0
2011-02-01 11:30:00	SPY	ETF	130.16	130.52	130.155	130.38	8419840.0
2011-02-01 12:00:00	SPY	ETF	130.39	130.71	130.35	130.64	8896182.0
2011-02-01 12:30:00	SPY	ETF	130.6317	130.89	130.56	130.89	8923278.0
2011-02-01 13:00:00	SPY	ETF	130.88	130.94	130.76	130.84	7743620.0
2011-02-01 13:30:00	SPY	ETF	130.84	130.87	130.66	130.675	8987223.0
2011-02-01 14:00:00	SPY	ETF	130.67	130.791	130.66	130.67	5068098.0
2011-02-01 14:30:00	SPY	ETF	130.67	130.82	130.59	130.8	10078295.0
2011-02-01 15:00:00	SPY	ETF	130.81	130.86	130.7	130.8238	7414692.0
2011-02-01 15:30:00	SPY	ETF	130.83	130.97	130.74	130.75	21673705.0
2011-02-01 16:00:00	SPY	ETF	130.74	130.93	129.465	130.6	10540661.0
2011-02-01 16:30:00	SPY	ETF	130.62	130.64	129.6569	130.61	4055592.0
2011-02-01 17:00:00	SPY	ETF	130.61	130.8154	130.5294	130.58	1290605.0
2011-02-01 17:30:00	SPY	ETF	130.58	130.61	130.56	130.59	23529.0
2011-02-01 18:00:00	SPY	ETF	130.61	130.71	130.49	130.57	164684.0
2011-02-01 18:30:00	SPY	ETF	130.57	130.61	130.47	130.6	82511.0
2011-02-01 19:00:00	SPY	ETF	130.58	130.67	130.55	130.64	48400.0
2011-02-01 19:30:00	SPY	ETF	130.64	130.72	130.62	130.72	18249.0
2011-02-01 04:00:00	QQQ	ETF	56.21	56.21	56.21	56.21	306.0
2011-02-01 05:00:00	QQQ	ETF	56.32	56.32	56.32	56.32	200.0
2011-02-01 05:30:00	QQQ	ETF	56.33	56.33	56.33	56.33	100.0
2011-02-01 06:30:00	QQQ	ETF	56.37	56.37	56.34	56.35	1600.0
2011-02-01 07:00:00	QQQ	ETF	56.33	56.35	56.31	56.31	26413.0
2011-02-01 07:30:00	QQQ	ETF	56.31	56.38	56.3	56.37	42026.0
2011-02-01 08:00:00	QQQ	ETF	56.36	56.39	56.02	56.38	221186.0
2011-02-01 08:30:00	QQQ	ETF	56.37	56.42	56.29	56.37	187177.0
2011-02-01 09:00:00	QQQ	ETF	56.38	56.42	56.0	56.42	178516.0
2011-02-01 09:30:00	QQQ	ETF	56.4194	56.66	56.36	56.6	8906991.0
2011-02-01 10:00:00	QQQ	ETF	56.6	56.78	56.51	56.74	5882557.0
2011-02-01 10:30:00	QQQ	ETF	56.74	56.92	56.7	56.89	5063420.0
2011-02-01 11:00:00	QQQ	ETF	56.89	56.94	56.73	56.799	4026347.0
2011-02-01 11:30:00	QQQ	ETF	56.8	56.97	56.7901	56.929	6989508.0
2011-02-01 12:00:00	QQQ	ETF	56.92	57.17	56.91	57.12	7865091.0
2011-02-01 12:30:00	QQQ	ETF	57.12	57.15	57.06	57.15	2268492.0
2011-02-01 13:00:00	QQQ	ETF	57.15	57.18	57.06	57.1	2244279.0
2011-02-01 13:30:00	QQQ	ETF	57.1	57.14	57.04	57.06	5218214.0

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

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