PREVIEW / etf_30min / 2010-04-19

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-19.parquet
  size:    261 KB
  rows:    8,641

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-04-19 04:00:00	SPY	ETF	119.02	119.08	119.02	119.03	5750.0
2010-04-19 04:30:00	SPY	ETF	119.0	119.0	118.8	118.94	2300.0
2010-04-19 05:00:00	SPY	ETF	118.78	118.78	118.78	118.78	200.0
2010-04-19 05:30:00	SPY	ETF	118.94	118.94	118.83	118.88	22500.0
2010-04-19 06:00:00	SPY	ETF	118.92	118.98	118.9	118.97	14800.0
2010-04-19 06:30:00	SPY	ETF	118.95	119.0	118.85	118.96	15300.0
2010-04-19 07:00:00	SPY	ETF	118.98	118.98	118.66	118.87	355026.0
2010-04-19 07:30:00	SPY	ETF	118.89	118.94	118.81	118.92	290945.0
2010-04-19 08:00:00	SPY	ETF	118.89	119.41	118.76	118.83	1026843.0
2010-04-19 08:30:00	SPY	ETF	118.83	119.04	118.81	119.03	1412806.0
2010-04-19 09:00:00	SPY	ETF	119.02	119.12	118.98	119.02	1228966.0
2010-04-19 09:30:00	SPY	ETF	119.01	119.67	118.98	119.49	28522510.0
2010-04-19 10:00:00	SPY	ETF	119.48	119.81	119.42	119.485	18045945.0
2010-04-19 10:30:00	SPY	ETF	119.49	119.56	119.21	119.33	18003841.0
2010-04-19 11:00:00	SPY	ETF	119.32	119.39	119.06	119.1499	11296093.0
2010-04-19 11:30:00	SPY	ETF	119.15	119.24	118.61	118.73	21266777.0
2010-04-19 12:00:00	SPY	ETF	118.74	118.86	118.47	118.72	17461592.0
2010-04-19 12:30:00	SPY	ETF	118.73	118.96	118.655	118.91	7679502.0
2010-04-19 13:00:00	SPY	ETF	118.89	118.98	118.7	118.91	7511173.0
2010-04-19 13:30:00	SPY	ETF	118.92	118.96	118.64	118.66	8036726.0
2010-04-19 14:00:00	SPY	ETF	118.66	119.33	118.57	119.26	14261276.0
2010-04-19 14:30:00	SPY	ETF	119.26	119.58	119.21	119.56	14407020.0
2010-04-19 15:00:00	SPY	ETF	119.56	119.76	119.51	119.7	14054851.0
2010-04-19 15:30:00	SPY	ETF	119.7	119.93	119.5	119.85	18512222.0
2010-04-19 16:00:00	SPY	ETF	119.84	120.12	118.7	120.01	10187945.0
2010-04-19 16:30:00	SPY	ETF	120.02	120.08	119.94	119.96	558232.0
2010-04-19 17:00:00	SPY	ETF	119.98	120.05	119.3319	120.03	2121636.0
2010-04-19 17:30:00	SPY	ETF	120.03	120.04	119.97	120.0	28161.0
2010-04-19 18:00:00	SPY	ETF	119.99	120.04	119.99	120.02	184387.0
2010-04-19 18:30:00	SPY	ETF	119.99	120.07	119.98	120.06	30920.0
2010-04-19 19:00:00	SPY	ETF	120.06	120.06	120.04	120.05	21407.0
2010-04-19 19:30:00	SPY	ETF	120.05	120.1	120.05	120.09	114400.0
2010-04-19 04:00:00	QQQ	ETF	49.4	49.4	49.39	49.39	600.0
2010-04-19 04:30:00	QQQ	ETF	49.37	49.37	49.37	49.37	500.0
2010-04-19 05:30:00	QQQ	ETF	49.28	49.28	49.28	49.28	4400.0
2010-04-19 06:00:00	QQQ	ETF	49.36	49.36	49.36	49.36	200.0
2010-04-19 07:00:00	QQQ	ETF	49.3	49.31	49.25	49.3	38147.0
2010-04-19 07:30:00	QQQ	ETF	49.31	49.33	49.28	49.32	80735.0
2010-04-19 08:00:00	QQQ	ETF	49.33	49.38	49.25	49.33	264627.0
2010-04-19 08:30:00	QQQ	ETF	49.33	49.41	49.33	49.41	351617.0
2010-04-19 09:00:00	QQQ	ETF	49.4	49.41	49.36	49.36	423995.0
2010-04-19 09:30:00	QQQ	ETF	49.36	49.66	49.35	49.57	11282696.0
2010-04-19 10:00:00	QQQ	ETF	49.57	49.64	49.41	49.449	10179063.0
2010-04-19 10:30:00	QQQ	ETF	49.45	49.47	49.28	49.3295	5982154.0
2010-04-19 11:00:00	QQQ	ETF	49.32	49.35	49.21	49.26	3869195.0
2010-04-19 11:30:00	QQQ	ETF	49.2567	49.32	48.98	49.03	5646648.0
2010-04-19 12:00:00	QQQ	ETF	49.03	49.06	48.9	48.98	7429217.0
2010-04-19 12:30:00	QQQ	ETF	48.99	49.1	48.97	49.06	3703360.0
2010-04-19 13:00:00	QQQ	ETF	49.06	49.07	48.93	49.04	4095216.0
2010-04-19 13:30:00	QQQ	ETF	49.04	49.08	48.94	48.9462	4897663.0

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

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