PREVIEW / etf_30min / 2010-07-07

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-07-07.parquet
  size:    254 KB
  rows:    8,421

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-07-07 04:00:00	SPY	ETF	102.46	102.51	102.46	102.51	850.0
2010-07-07 04:30:00	SPY	ETF	102.45	102.45	102.31	102.31	1550.0
2010-07-07 05:00:00	SPY	ETF	102.34	102.34	102.19	102.19	1650.0
2010-07-07 05:30:00	SPY	ETF	102.19	102.33	102.19	102.33	1100.0
2010-07-07 06:30:00	SPY	ETF	102.36	102.65	102.36	102.65	24800.0
2010-07-07 07:00:00	SPY	ETF	102.68	102.81	102.62	102.81	212450.0
2010-07-07 07:30:00	SPY	ETF	102.82	102.89	102.62	102.65	201894.0
2010-07-07 08:00:00	SPY	ETF	102.66	102.76	102.54	102.71	499603.0
2010-07-07 08:30:00	SPY	ETF	102.73	103.11	102.04	103.0	2287310.0
2010-07-07 09:00:00	SPY	ETF	103.0	103.18	102.87	103.12	2364908.0
2010-07-07 09:30:00	SPY	ETF	103.13	103.62	103.02	103.6	19866079.0
2010-07-07 10:00:00	SPY	ETF	103.6	104.13	103.6	103.83	21413950.0
2010-07-07 10:30:00	SPY	ETF	103.83	104.69	103.83	104.58	20671860.0
2010-07-07 11:00:00	SPY	ETF	104.58	104.63	104.16	104.42	17112950.0
2010-07-07 11:30:00	SPY	ETF	104.41	104.65	104.09	104.22	12098649.0
2010-07-07 12:00:00	SPY	ETF	104.22	104.47	104.2	104.46	10082677.0
2010-07-07 12:30:00	SPY	ETF	104.45	104.62	104.35	104.5	13362954.0
2010-07-07 13:00:00	SPY	ETF	104.51	105.09	104.48	105.03	13525983.0
2010-07-07 13:30:00	SPY	ETF	105.03	105.18	104.83	105.06	9131889.0
2010-07-07 14:00:00	SPY	ETF	105.05	105.25	105.05	105.07	12296854.0
2010-07-07 14:30:00	SPY	ETF	105.07	105.35	104.95	105.33	11913531.0
2010-07-07 15:00:00	SPY	ETF	105.34	105.69	105.11	105.64	21699319.0
2010-07-07 15:30:00	SPY	ETF	105.64	106.24	105.59	106.13	44988183.0
2010-07-07 16:00:00	SPY	ETF	106.14	106.46	103.075	106.36	11851741.0
2010-07-07 16:30:00	SPY	ETF	106.36	106.45	106.1505	106.41	4589479.0
2010-07-07 17:00:00	SPY	ETF	106.4	106.44	106.35	106.36	213068.0
2010-07-07 17:30:00	SPY	ETF	106.4	106.42	106.35	106.37	33475.0
2010-07-07 18:00:00	SPY	ETF	106.37	106.44	106.15	106.37	70221.0
2010-07-07 18:30:00	SPY	ETF	106.38	106.46	106.36	106.39	81457.0
2010-07-07 19:00:00	SPY	ETF	106.4	106.41	106.37	106.38	51479.0
2010-07-07 19:30:00	SPY	ETF	106.38	106.41	106.3	106.32	143652.0
2010-07-07 04:00:00	QQQ	ETF	42.61	42.61	42.55	42.55	16000.0
2010-07-07 04:30:00	QQQ	ETF	42.5	42.5	42.47	42.49	3900.0
2010-07-07 05:00:00	QQQ	ETF	42.51	42.51	42.43	42.43	3100.0
2010-07-07 05:30:00	QQQ	ETF	42.4	42.46	42.4	42.46	3600.0
2010-07-07 06:00:00	QQQ	ETF	42.42	42.42	42.42	42.42	4900.0
2010-07-07 06:30:00	QQQ	ETF	42.58	42.59	42.58	42.59	25300.0
2010-07-07 07:00:00	QQQ	ETF	42.59	42.64	42.58	42.64	5148.0
2010-07-07 07:30:00	QQQ	ETF	42.67	42.69	42.62	42.62	83229.0
2010-07-07 08:00:00	QQQ	ETF	42.63	42.67	42.56	42.64	954824.0
2010-07-07 08:30:00	QQQ	ETF	42.65	42.71	42.58	42.63	395459.0
2010-07-07 09:00:00	QQQ	ETF	42.64	42.77	42.6	42.74	524310.0
2010-07-07 09:30:00	QQQ	ETF	42.74	42.99	42.7	42.94	8996057.0
2010-07-07 10:00:00	QQQ	ETF	42.95	43.19	42.945	43.02	6381373.0
2010-07-07 10:30:00	QQQ	ETF	43.02	43.31	43.015	43.28	5139501.0
2010-07-07 11:00:00	QQQ	ETF	43.27	43.32	43.12	43.24	4046454.0
2010-07-07 11:30:00	QQQ	ETF	43.24	43.34	43.11	43.17	4496987.0
2010-07-07 12:00:00	QQQ	ETF	43.17	43.26	43.14	43.23	2686016.0
2010-07-07 12:30:00	QQQ	ETF	43.23	43.28	43.205	43.23	2721302.0
2010-07-07 13:00:00	QQQ	ETF	43.23	43.5	43.22	43.47	5999163.0

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

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